In the last issue I told you how to send out your ezine to a few subscribers by copying an Excel list of them into the 'Bcc:' (Blind Carbon Copy) slot.
The downsides to this method are:
1. You have no email record of who it went to, and
2. You can't personalize (e.g. Dear Harry) each message.
I got around these shortcomings by using MS Word's 'Merge' feature at: Tools/Letters and Mailings/Mail Merge Wizard.
First: write your newsletter in Word. If you plan to email it as text (like TIP) set its font (in the 3 top left slots) to "Plain Text---Courier New---10".
Next: End every line at 5" on your Word's top ruler.
Now click 'Tools' in the top menu, followed by 'Letters and Mailings', then 'Mail Merge Wizard', and follow directions.
To personalize your emails you'll need a second column in the Excel spreadsheet for "First Name" next to "Email". The 'Mail Merge Wizard' will tell you when to load it.
Test it first by sending it to your or your family's list of email addresses and names.
The two minor downsides I found with this method are:
1. Every email appears in your 'Sent Items' folder, which is good in that it confirms that they were sent, but it fills up this folder if you have a lot of emails; and
2. It stops at some names, and doesn't send them.
But there's another solution as you'll see in the next TIP.
Mail Merge Your Newsletter - To learn more about this author, visit Donald F. Pooley's Website.
Like this article? Share it with your friends
 |
Related Articles |
|
 Better Than Mail Merge
|
| |
In the last two issues you've learned two ways to send your email newsletter to clients, and other subscribers. Each has a downside, so I started looking for a suitable program to email TIP as the number of its sub...
|
|
Mail Merge Your Newsletter
|
| |
In the last issue I told you how to send out your ezine to a few subscribers by copying an Excel list of them into the 'Bcc:' (Blind Carbon Copy) slot.
|
|
No Pain No Gain 5 Step Sales Strategy
|
| |
Are you about to create a strategy to achieve your sales target? The following 5 steps are a must to help you on your way.
|
|
How To Make Your Own Ezine
|
| |
If you've read TIP #15 "Your Email Newsletter" you already know that TIP itself provides a template for your own email magazine* (or 'ezine').
|
|
How To Create Your Very Own Client Newsletter
|
| |
So you're thinking of using a client newsletter. That's good, because there are lots of reasons why using newsletters for business development is a good idea. Here's the biggest: a monthly newsletter is tops in s...
|
|
|
Donald F. Pooley
(Visit Donald's Website)
Don Pooley, the author of this article,
allows you to publish
it if you include these credit lines:
Copyright 2005, Donald F. Pooley, Inc.
Don Pooley CLU, CFP, CHFC, "The
Advisor's Advisor" has shared
his marketing know-how with audiences of
life insurance men
in all major Canadian cities, London,
Australia, Chicago, New
York, San Francisco, Hong Kong, and
Singapore, and now in his
free ezine. To get more ideas on marketing
your services, plus
free ebooks, subscribe now at www.eTIP.ca/
|
|
|
|
![[Get Copyright Permissions]](http://license.icopyright.net/images/icopy-w.gif){kind=small}
