staggered email send

**okmijn** · 03-22-2013, 05:29 AM

I have working macro that sends emails to every address in a column. As the number has increasd to over 200, my ISP wants me to stagger the email send to 100 per hour.

Is there a sensible way of doing this? I can write a delay in the macro but things get complicated when pages are closed, data is changed etc during that time as it all feeds from the main Excel database which is not static, certainly not over the 3-4 hours I would need to stagger the email send?

I've tried to find out a way of staggering it in Outlook instead but no luck there either.

I've thought about loading all the addreses into an array at first rather than reading them as it progresses. The toruble with this is if the databse is closed during this process, I've no way of knowing which emails have been sent other than dumping a sent list each time, but this starts sounding really messy.

Thanks in advance

**jaslake** · 03-23-2013, 05:02 PM

Hi okmijn

I had an issue with my ISP Provider in that I could not send the same Email to more than 100 Email Addresses. It's an anti-spam effort by the ISP. This doesn't sound like your issue but here was my solution...might work for you...

I broke the 120 Email Recipients into two Distribution Lists (with Code) and then sent the Email to each Distribution List. Might work for you.

**okmijn** · 03-27-2013, 06:11 AM

In case anyone else requires this, I solved it by using the following code:

Please Login or Register  to view this content.

The deferred time bit adds one minute to the send as a function of the email with outlook. In the email send loop, this can then be set by a count and delaying each email by a further 1 minute (or whatever you choose) to stagger them.

**mc84** · 05-02-2021, 10:11 PM

Hey okmijn,

Thanks for that code. However I seem to only be able to delay the send for the whole batch.

Is there a way I can delay the send for each email created in the merge? e.g. One email is sent, then 1 minute later the next email sends, and so forth?

Thanks
MC

**FDibbins** · 05-03-2021, 12:15 AM

Originally Posted by mc84

Hey okmijn,

Thanks for that code. However I seem to only be able to delay the send for the whole batch.

Is there a way I can delay the send for each email created in the merge? e.g. One email is sent, then 1 minute later the next email sends, and so forth?

Thanks
MC

Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #4 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread