VBA Macro for Sending mails to a list in excel - with fixed time intervals

[shetalshah]

Hi All!

I have a list of emails in one sheet & the email draft in another (which contains text & images).
I need a code to automatically send the email draft from sheet 2 to every 5 people in the list provided in sheet 1 (this is because our mail server has a restriction of sending only 5 mails per minute).
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.
And then this goes on.... The code should run until the end of the entire list.

The code should 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

 

[James006]

Hi,

Your question is NOT related to sending mails ...

It is related to how to monitor timing in a macro ....

You do need to use Application.OnTime

see : Application.OnTime method (Excel)

Hope this will help

 

[shetalshah]

Hi James!

I want to Monitor time & send the mails according to a condition of time.

I cant write codes on my own. And hence need someone's help...

 

[James006]

Hi again,

At least, we agree on the fact that Sending mails is not the topic ...

In order to schedule your macro, a good explanation follows :

Schedule a Macro with VBA Application.OnTime - wellsr.com

The VBA Application.OnTime method lets you schedule the execution of an Excel macro at a certain time. Scheduling a macro to run at a specified time is useful.

wellsr.com

Hope this will help