Word - mail merge, scheduled sending of the email.

Posted on 2013-10-07
Medium Priority
Last Modified: 2013-10-08
My OS is win 7 prof 64 bit , msn email - the free one, and I use office 2007.  I do a monthly mail merge sometimes using  Word but as MSN has a limit of the number of emails that can be sent per day, i.e. 100 and my list is 160, I would like to send the emails in staggered batches.  Eg ID 1 to 50 at 6 pm today, and then 51 to 90 at 9 pm today, and 91 to say 120 at 9 am tomorrow and the rest from say at 3 pm tomorrow.  
Can this be done either using Word or is there any Add ON.  The emails data comes from an Access 2007 query.  I use Outlook 2007 to send the emails.
Thank u for your guidance.
Question by:jegajothy
  • 3
LVL 17

Accepted Solution

Kent Dyer earned 1600 total points
ID: 39554350
At the risk of placing my neck out there..


There are some great tools out there.  Sue Mosher who started the site, is very knowledgeable with Outlook and related tools.
LVL 10

Assisted Solution

etech0 earned 400 total points
ID: 39555628
Maybe you want to think about switching to gmail....

Another easyish way would be to add a field in access for "Mailing list". You can give everyone a value of a, b, or c (put 50 in each).  Then you could just do 3 different mail merges, and each day filter the query so that you only get the people in one of the mailing list. That way you'll only get 50 people in each batch.

Author Comment

ID: 39555896
Thank u for your responses.  in response to etech0, I am following your suggestion at the moment.  when I do the email merge, I set to merge from ID to To ID.  Let me check out kdyer's suggestion meanwhile.  Thank u again.

Author Comment

ID: 39556018
I have to return to respond to Kyder's suggestion.  It is an awesome link, and it meets all my needs.  I have used iContacts, and MailChimp, and I think the tools incorporate everything that I can of doing, thank u.

Author Closing Comment

ID: 39556024
Thank u for both suggestions, which work great.  Thanks.

Featured Post

Easily manage email signatures in Office 365

Managing email signatures in Office 365 can be a challenging task if you don't have the right tool. CodeTwo Email Signatures for Office 365 will help you implement a unified email signature look, no matter what email client is used by users. Test it for free!

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

This tutorial is about creating a new Microsoft Online User Profile account along with how to transfer your files and settings. You may be faced with this situation if your existing user profile has become corrupted.
I tried to use the SharePoint app to Import a Spreadsheet and import an Excel sheet into a Team site made in SharePoint 2016. But that just resulted in getting an error message 'Unknown Error'...
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
If you are looking for an automated tool which can generate reports for Outlook emails and other items from PST file, then you can go for Kernel PST Reporter tool. The reports which are created by this tool are helpful to analyze and understand PST …

600 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