Outlook - Staggered send for mailing lists

[RichCowell]

Hi all,

I use Office for emails to the members of the Association I run, writing the emails in Word from a list in Excel, and sending via Outlook.

There are anywhere between 100-1,100+ emails going out, and I really need to stagger them more to avoid being flagged as spam.

Can anyone help me with a script that could run on all the emails in the Outbox and send them gradually, maybe like 1 or 2 per minute...

I think there are third party programmes that can do this, but I'd rather do it without having to pay out.

Thanks :0)

 

[RichCowell]

Could be worth mentioning that I always put Outlook to Work Offline before I do the merge, so I can make sure everything's okay before they send, and add any attachments etc.

So it will be offline already, which would make manually running a macro easier.

 

[Macropod]

See, for example: Microsoft Office Forums - View Single Post - [Solved] Email Merge With Delay & Microsoft Office Forums - View Single Post - [Solved] Catalogue Email Merge with Delay Between Messages

 

[RichCowell]

Thanks @Macropod - they're macros in Word rather than Outlook though and I don't think it'd be suitable in this case.

I really need one to work with Outlook as the emails all have personalised subjects with their name and other merge fields.

 

[Macropod]

The macros do work with Outlook - or any other email application that can be used with mailmerges. And, since you're doing a mailmerge, it is presumably being run through Word (or, perhaps, Publisher). Hence, that's where the macro goes - in the application that sends the emails to your email app.

 

[MarkPaul]

Thanks for the post! I used the macro and it worked. Except for it is not staggering. --- I changed the value in the code that Macropod provided from (10) to (60) since I want it to send out one email per minute. But it sent them out one per second. -- I even troubled shooted by seeing if changing the Execute Pause from "False" to "True" would make a difference (which it did not). Any tips? Thanks!

 

[Macropod]

Works as described for me...

 

[MarkPaul]

Thanks for your input. It may be the way I am setting up the macro. Seems to be defaulting to an earlier version of the macro when I run it. Thanks again!