Automatically send emails at regular interval

[talhaparvaiz@yahoo.com]

Hello,


I'm looking to automate the sending of marketing emails to around 1000 recipients. I want to avoid sending them all at once to prevent being flagged as spam.
Each email will have the same body text, subject line, and attachment. we just have to send email by changing the TO email address.
Could you please advise on how to schedule the sending of emails at regular intervals? I intend to store the recipients' email addresses in a table.

Thanks

[June7]

Why would sending 1000 emails cause them to be flagged as spam? Review https://blog.catsone.com/blog/2019/0...-spam-filters/

Are you sending 1 email with 1000 addresses, or 1000 individual emails?

[Gicu]

It can be done in few ways, here are two:
-keep your Access application open with a form open and use the form Timer event to send batches of emails
-use the built in Windows scheduler to open the Access application at certain times\intervals and use the AutoExec macro in the app to send each batch of emails (or use the Open or Load event of the form set as the opening form)
I would recommend using BCC instead of TO as that will ensure the recipients won't see the other email addresses in the batch. To split the 1000 emails into batches you can use a Top X (50,100, etc.) query on the remaining records that weren't already sent in the current session (after you send a batch you run a update query to populate the DateSent field in the table, the the top query uses Is Null for the criteria in that field).
Cheers,