Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Delay Mail Merge in Doc

Posted on 2014-04-07
6
Medium Priority
?
814 Views
Last Modified: 2014-04-10
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
Comment
Question by:damixa
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 7

Accepted Solution

by:
COACHMAN99 earned 2000 total points
ID: 39983794
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
 
LVL 70

Expert Comment

by:Éric Moreau
ID: 39983795
Have you considered using your own SMTP server that wouldn't restrict you?
0
 
LVL 7

Expert Comment

by:COACHMAN99
ID: 39983806
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
Fill in the form and get your FREE NFR key NOW!

Veeam® is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

 
LVL 46

Expert Comment

by:aikimark
ID: 39984490
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
 

Author Comment

by:damixa
ID: 39986279
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
 
LVL 70

Expert Comment

by:Éric Moreau
ID: 39986303
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

Featured Post

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
Suggested Courses

715 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question