Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 902
  • Last Modified:

Delay Mail Merge in Doc

I have a mailmerge that has to send about 10,000 emails

Since my server only allows me to send about 250 emails an hour, I was wondering if I can create a delay in the mailmerge that will send about 200 emails an hour, so I can spread the 10K emails over 50 hours.

Is it possible to add some vba code to the mailmerge that will wait about 15 seconds before sending the next email.

thanks,
Vinnie
0
damixa
Asked:
damixa
1 Solution
 
COACHMAN99Commented:
If you are cycling through a recordset then a delay would work e.g

Private Declare Sub sapiSleep Lib "kernel32" _
        Alias "Sleep" _
        (ByVal dwMilliseconds As Long)

Sub sSleep(lngMilliSec As Long)
    If lngMilliSec > 0 Then
        Call sapiSleep(lngMilliSec)
    End If
End Sub
0
 
Éric MoreauSenior .Net ConsultantCommented:
Have you considered using your own SMTP server that wouldn't restrict you?
0
 
COACHMAN99Commented:
Further to my delay suggestion:
You should probably close the recordset (and keep track of where you are), or put the merge data into a temp table; to avoid locking issues, timeouts etc.
0
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

 
aikimarkCommented:
I would suggest you create a scheduled task that would launch the mail merge every hour.  Change your processing to only get the Top 250 rows from the source.  Change the source records to indicate that they have been emailed, preventing duplicate processing.
0
 
damixaAuthor Commented:
Eric,
As far as creating my own mail server, are there any limitations from my isp provider? I have a play server at home with Windows Server in it. I just didnt know if comcast (my ISP provider limits me in any way to send 30K emails
0
 
Éric MoreauSenior .Net ConsultantCommented:
Are you connected to a company server with your own Exchange server?

If this is the case, you could install the SMTP server on it. If your Exchange doesn't block you (or ask your sysadmin to unblock it for your particular SMTP server), you will be fine.

If you are at home connected directly to a ISP, you will have to contact them to find a way. ISP throttles emails to ensure not being used as a spammer.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now