How to Use Mail Merge in Outlook to Send out Personalized Publisher Newsletters to a Distribution List
Posted in WordPress on Jul 23, 2014
If you produce an e-mail e-newsletter in Microsoft Publisher, you have in all probability run into the identical trouble that I did – distributing the publication immediately after developing it. Publisher will allow you to mail the file as an electronic mail information (File -> Send Electronic mail) but shockingly will not allow you to send it to a distribution listing.
This is good if you only want to send out it to a several people, or if you never have to stress about producing everyone’s email obvious to every person else in the group. But what if you deliver a enterprise newsletter to purchasers? Or if you want to personalize just about every message (for example, placing each individual persons title in the salutation as opposed to a generic one particular)?
Beforehand, the only possibilities that I noticed ended up to deliver it to just about every human being separately (can come to be really time consuming) or ship it to the distribution list as a BCC (Blind Carbon Duplicate). BCC’s are poor for two causes – one, they tend to be quickly filtered out as spam, and two, they never enable for personalization.
Most individuals will explain to you that if you are in this scenario it is time to enhance to skilled e-mail application. I personally like carrying out my e-newsletter structure in Publisher and would favor to keep on to use Publisher. I also like making use of Outlook distribution lists. I have a script that sends me the list of persons that are signed up to my newsletter each individual thirty day period in a format that basically copies and pastes into a working Outlook distribution list.
So I arrived up with a perform-all over that I now use for my publication:
Phase one: Create your E-newsletter in Publisher
I use the time period ‘newsletter’ but any Publisher file can be sent via electronic mail, so regardless of what your software you can place this strategy to do the job for you.
Stage two: Create your Distribution Record in Microsoft Outlook
If you are not familiar with Distribution Lists, there is a tutorial at [http://www.informit.com/articles or blog posts/report.asp?p=417511&seqNum=3]
Stage three: Send out your Publication to Yourself
In Publisher, go to (File -> Deliver Electronic mail -> Send out This Web site as Concept) and e-mail it to your electronic mail account in Microsoft Outlook.
Stage 4: “Forward” the Publication to the Distribution List utilizing a Mail Merge
At this point, you have gained your newsletter at your electronic mail account in Outlook and you no longer require Publisher. Essentially, the relaxation of the course of action is just forwarding your newsletter to your Distribution Listing utilizing a Mail Merge, some thing you are not able to do when sending via Publisher. This is composed of a number of actions:
1. Save your Distribution Record in Rich Textual content Format by opening the List and picking out File -> Help save As.
two. Open up the record, delete any headings, and swap them with headings for the fields in your distribution listing, separating every single heading with a tab. For case in point, if your distribution listing is made up of first title, previous identify, and electronic mail address, you would want to list those headings in the get they seem, separating them with a tab.
3. Click Ahead on the e-mail that you sent by yourself and delete the traces of textual content that clearly show the receiver that it is a forwarded electronic mail.
four. Click in the entire body of the concept, and pick out Tools -> Letters and Mailings -> Mail Merge.
5. Opt for E-mail Messages and strike Upcoming.
six. Select Use the present doc and hit Up coming.
seven. Click Search and choose your Distribution Checklist. Your listing really should show up, simply click Okay and then click Future.
8. Use the More Goods menu to insert any individualized messages. For example, you could greet each receiver personally by inserting their name at the prime of the electronic mail. Simply click Up coming when entire.
9. Edit your receiver record if you like. Otherwise, click Upcoming to full the merge.
That is it! Now you can now send your Publisher e mail as a Mail Merge!
By Adam McFarland