How do I throttle mail merge with vba

John Hawkins 0 Reputation points
2024-04-15T01:14:44.24+00:00

My mail service has a limit of 25 emails a minute and i run a photographic competition where i have up to 600 entrants that i need to email to in bulk with Word and Excel. This is all non-profit and not regular enough to buy an add on to it. Is there a way in VBA to throttle the emails to 1 per say 7 seconds.

Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,976 questions
Word Management
Word Management
Word: A family of Microsoft word processing software products for creating web, email, and print documents.Management: The act or process of organizing, handling, directing or controlling something.
931 questions
0 comments No comments
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.