Hello Every one I have file containing 2 sheets the first sheet containing a certain range witch I want to send it by email to many email addresses stored in in Sheet 2 Column A as following Sending one by one but he has to wait 10 seconds before sending the following one ( as the conditions to my server ) after sending he has to write beside each email in Sheet 2 column B "sent". once I run the Macro he has to send 400 emails and stop. when I re-run the macro he has to continue the cycle to the emails not sent ( column B) Any help please ?

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Mailing List

Thread starter hriad
Start date Apr 14, 2022

hriad

New Member

Apr 14, 2022

Hello Every one
I have file containing 2 sheets
the first sheet containing a certain range witch I want to send it by email to many email addresses stored in in Sheet 2 Column A as following

Sending one by one but he has to wait 10 seconds before sending the following one ( as the conditions to my server )
after sending he has to write beside each email in Sheet 2 column B "sent".
once I run the Macro he has to send 400 emails and stop.
when I re-run the macro he has to continue the cycle to the emails not sent ( column B)

Any help please ?