Log in  \/ 
x
or
x
x
Register  \/ 
x

or

unanswered VBA Macro for Sending mails to a list with time intervals

  • mr.shetalshah@gmail.com
  • mr.shetalshah@gmail.com's Avatar Topic Author
  • Offline
More
4 months 2 weeks ago #1939 by mr.shetalshah@gmail.com
VBA Macro for Sending mails to a list with time intervals was created by mr.shetalshah@gmail.com
Hi All!

I have a list of emails in one sheet & the email draft in another.
I need a code to automatically send the email draft from sheet 2 to every 5 members in the list provided in sheet 1.
Once the first 5 are sent, the code should tag them as "Sent" in a new dedicated column & then wait for 60 seconds before sending out the next set of 5 emails.
The code should run until the end of the entire list.

The code can use outlook to send out the mails from the default profile in outlook.

Please help.

Let me know in case if you need any more clarifications

Please Log in or Create an account to join the conversation.

Moderators: jaychivoExcelfansqiuhongkun