Mail Merge Your Newsletter
|
| Tweet |
|
Free PDF Download Banks Cant Sell - By Donald F. Pooley |
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.
Related Articles
|
Free PDF Download Banks Cant Sell - By Donald F. Pooley |
|
About the Author: Donald F. Pooley RSS for Donald's articles - 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 http://www.eTIP.ca/ Click here to visit Donald's website. Getting Business to Come to You How To Make Your Own Ezine Go Where the Money Is List Your Wants When They Answer The Phone |
Related Forum Posts
Share this article. Fund someone's dream.
Share this post and you'll help support entrepreneurs in Africa through our partnership with Kiva.
Over $50,000 raised and counting - Please keep sharing! Learn more.
Trending Articles
|
|
Like this page? PLEASE +1 it! |
Newsletter
Get advice & tips from famous business
owners, new articles by entrepreneur
experts, my latest website updates, &
special sneak peaks at what's to come!
Get advice & tips from famous business
owners, new articles by entrepreneur
experts, my latest website updates, &
special sneak peaks at what's to come!
Popular Articles
Fail to Plan, Plan to Fail
Want To Know How To Make Money With Clickbank?
Internet Guerilla Marketing Tactics
Fail to Plan, Plan to Fail
Want To Know How To Make Money With Clickbank?
Internet Guerilla Marketing Tactics
Suggestions
Email us your ideas on how to make our
website more valuable! Thank you Sharon
from Toronto Salsa Lessons / Classes for
your suggestions to make the newsletter
look like the website and profile younger
entrepreneurs like Jennifer Lopez.
Email us your ideas on how to make our
website more valuable! Thank you Sharon
from Toronto Salsa Lessons / Classes for
your suggestions to make the newsletter
look like the website and profile younger
entrepreneurs like Jennifer Lopez.







