Evan Carmichael Top Header about About About facebook Twitter YouTube Google+

Mail Merge Your Newsletter



Free PDF Download
Banks Cant Sell - By Donald F. Pooley

Name: Email:


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

  Better Than Mail Merge
  No Pain No Gain 5 Step Sales Strategy
  The Best Internet Marketing Tool: An E-Mail Newsletter
  Duplicate Customers or Vendors in QuickBooks? Merge Them!
  The Three Core Components of Your On-Line Presence
  How To Make Your Own Ezine
  Assumptions
  6 Ways an E-Newsletter can Grow a Business
  How To Create Your Very Own Client Newsletter
  10 Key Points: Writing E-mails That Sell
  How Many Newsletter Subscribers Are You Losing Every Week?
  Email marketing—top way to build client relationships
  A High Earners Favourite
  How to Find Subscribers for Your E-Mail Newsletter
  Mail and Email
  Convincing People To Join Your Mailing List
  E-newsletters: why they're good for business
  Sales Prospecting for Long-Term Success
  Market Party Plan Business With Autoresponder Series
  Build a Referral Program for your E-zine

Home > Marketing > Donald F. Pooley > Mail Merge Your Newsletter >

Free PDF Download
Banks Cant Sell - By Donald F. Pooley

Name: Email:

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.
Dashed Line

More from Donald F. Pooley
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

Re: Would you like an EvanCarmichael.com Forum e-newsletter? Re: Would you like an EvanCarmichael.com Forum e-newsletter?
Re: Is Bulk Mailing useful for promotion Re: Is Bulk Mailing useful for promotion
Try Email Marketing, You Will Get Traffic Try Email Marketing, You Will Get Traffic
Top Franchises For 2007 Top Franchises For 2007
Toronto Coffee Millionaire Training Toronto Coffee Millionaire Training

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.
Share for a Cause



Worksheets
By: Evan Carmichael

Do you have what it takes to be an entrepreneur?

8 Powerful Steps to Finding Your Passion

Does your pitch suck?

Create a plan of attach to launch your new business.

8-Cover

Like this page? PLEASE +1 it! Evan Signature
Bottom Footer



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!
Name:
Email:
Popular Articles

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.