Feedback Form
Home Features Mastermind Videos About Advertise Blog Network Contact
   

Have A Suggestion?
Toronto Salsa Classes / Toronto Salsa Lessons 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 and Sean Combs!
Have A Suggestion?

Featured Ebook


ebook Famous Entrepreneurs - Modern Empire Builders


Featured Ebook

More Evan Carmichael
Have A Suggestion?

Sales Lessons From Starbucks And Dell

Mail Merge Your Newsletter



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.
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
[Get Copyright Permissions] E-Mail | Print | More  


Related Articles 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...

Related Forum Posts Related Forum Posts
Re: How To Track Offline Sales To Your Site Re: How To Track Offline Sales To Your Site
Earning a million before age 20 Earning a million before age 20
Facebook: $3,200 in new revenue Facebook: $3,200 in new revenue
Franchising - Behind the scenes Franchising - Behind the scenes
Trendy Biz Opp - stuff 2 know Trendy Biz Opp - stuff 2 know
Who and What Are Your Favorite Newsletter Authors? Who and What Are Your Favorite Newsletter Authors?
Take a vacation and run your biz Take a vacation and run your biz
Online Sales-Keep it Simple! Online Sales-Keep it Simple!

 
About the Author


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/
Have A Suggestion?

View Author's Blog
Become An Author

View Author's Video
Become An Author

Free Downloads


Donald F. Pooley's

Complete
List Of
Marketing
Articles

First Name
Last Name
Email
 
If you enjoyed this article, get Donald F. Pooley's Complete List of Marketing Articles For FREE!

More Donald F. Pooley
Generating Referrals From Clients
Start a Referral Club
Create High Impact Copy
Silence Really Is Golden
Four Square Organizer
Are You Hit and Run
But Is the Pope a CFP
Content Is King
What Makes A Champion
4 Dynamic Marketing Tactics
Become An Author