Word 2007 - mail merge
Posted on 2013-06-13
My OS is win 7 prof 64 bit and I use office 2007.
i use Word's mail merge feature to email thru Outlook announcements and since it is a small amount of about 150 emails, thus my decision not to use vendors like iContacts, etc.
My first attempt hit a relay problem when the emails were sitting in my Outlook's Outbox not being sent even after 1 day.
To merge the email data, i run a simple query to extract the email field from the Access database.
To overcome this relay problem I am thinking of putting a sleep command, so that after sending each email, there will be a pause of say like 30 seconds before sending out the next email.
If this can be done, can the Experts please advise, where and how should I insert the code. Should i put it in the Word's merge document, or in the query in Access or in Outlook.
The code that I have which I am not sure whether will work or not is as follows :
Option Compare Database
Private Declare Sub APISleep Lib "kernel32" Alias "Sleep" (ByVal lngMilliseconds As Long)
Public Function Sleep(lngSeconds As Long) As Boolean
If lngSeconds > 0 Then
Call APISleep(lngSeconds * 1000)
Sleep = True
I will then call it with the syntax Sleep 20
Hope the experts can please suggest a solution. Thank u.