Feedback Form
Home Features Mastermind Forums About Advertise Blog Network Contact Be An Author

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

Article Feedback
 Article Feedback No article feedback found.
  Leave Your Feedback
article feedback

Article Feedback
Dianne Crampton

Dianne Crampton is an executive leadership coach, team culture consultant, author and president of TIGERS Success Series, Inc. Dianne has been helping CEO's and Executives connect their employees to their core values and goals for over 20 years using the trademarked TIGERS team culture process, which stands for trust, interdependence, genuineness, empathy, risk and success. To download a free white paper on behaviors that build strong teams and behaviors that will predictably tear them down go here.

Dianne's contribution to the 2010 Pfeiffer Consulting Journal (an imprint of John Wiley and Sons Publishers) entitled TIGERS Hearted Teams is available in November 2009.  Her new book TIGERS Among Us: 5 Winning Business Team Cultures And Why, Three Creeks Publishing will release in March 2010.  To receive publishing discounts, subscribe to the free TigerTracks Newsletter here.

- Visit Dianne Crampton's Website

Stephanie Robey
Stephanie Robey is President and CoFounder of Pivot Positive, LLC - an Internet marketing business focused on helping people start work at home ventures. Previously, she was employed at The Search Agency with over 20 years experience in graphic design and 10 years experience in online marketing. She was responsible for launching the Conversion Path Optimization (CPO) unit where she and her team have conducted hundreds of optimization tests for online companies across multiple verticals.

She is a successful entrepreneur having started and sold 2 companies and remains on the board of directors of the third, PhotoSpin.com   Stephanie began her career in the direct marketing realm creating and producing direct mail for many of the major cable television companies and directly attributes her understanding of Internet marketing to those early offline experiences.  Stephanie is a graduate of San Diego State University with a BFA in Graphic Arts and also holds an Executive MBA from the Graziadio School of Business and Management at Pepperdine University.

Read Steph's Blog
Meet Steph and Dave
Sign up for our Free 7-Day BootCamp: Self Employed & Rich
- Visit Stephanie Robey's Website


To learn more about the Evan Elite Author Program please contact us.

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 http://www.eTIP.ca/

Donald F. Pooley is a Platinum author on EvanCarmichael.com
About The Author

View Author Blog
View Author Blog

View Author Video
View Author Video

Free Downloads


Donald F. Pooley's

Complete
List Of
Marketing
Articles

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

More Donald F. Pooley
Cold Call Concepts
Get This Book
How Can I Go On
Spread The Word Your Word
What Business Are You In
What Does Your E Address Tell People About You
Do It Again
Are Your Business Cards Lazy
Wheres the Benefit
How Do High Earners Prospect
Free Downloads


 
 
 


Evan Elite Authors
David Acheson  
Jeff Foster  
Stephanie Robey  
Evan Elite Authors

Become An Author
Have you written articles that would be of value to entrepreneurs? Become an expert on our site by publishing them! Expose yourself to a wide audience, drive more traffic to your website and get more sales! Click Here for details.
Become An Author

Evan's Latest Video
Modeling the Masters: Learn the true secrets behind Walt Disney's business success factors & grow your company! Video produced by Phanta Media
Evan's Latest Video

Business Opportunities
"Learn straight from Evan how you can Make a Full Time Income (And More) from a Website"

How to Start An Online Business

Click Here To Learn More
Business Opportunities



Evan's 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:
Evan`s Newsletter

Free Downloads
How To Double Your Business Icon How To Double Your Business
The Money Game Icon The Money Game
New Sales Leadership Paradigm Icon New Sales Leadership Paradigm
Small Business Financing Icon Small Business Financing
Canadian Leadership Icon Canadian Leadership
Free Downloads - Complete List

Entrepreneur Tools and Guides
Top 50 Political Blogs
Top 50 Political Blogs
Top Political Blogs of 2009
 
Top 50 Blogs For Startups To Watch In 2008
Top 50 Blogs For Startups
Top Blogs To Watch In 2008
 
Entrepreneur Tools and Guides

SEO For Africa
SEO For Africa
Akpene Ata Adéta, Togo,
Akpene Ata
Adéta, Togo
SEO For Africa

If I Were A Startup...
Stephen Pollack, $1.2 to $16.2 Mil in 3 Years
Stephen Pollack
$1.2 to $16.2 Mil in 3 Years
Lisa Shepherd, $335k to $1.1 Mil in 2 years
Lisa Shepherd
$335k to $1.1 Mil in 2 years
If I Were A Startup... - Complete List

Famous Entrepreneurs
Terry Matthews, Mitel
Mark Cuban, Broadcast.com
Mark Cuban
Broadcast.com
Famous Entrepreneurs - Complete List

Entrepreneur Advice
Keith Ferrazzi, Never Eat Alone
Keith Ferrazzi
Never Eat Alone
Tom Peters, In Search Of Excellence
Tom Peters
In Search Of Excellence
Entrepreneur Advice - Complete List

Popular Articles
(Premium Authors)

     Successful Salespeople - Sell with Passion and Manage by Process - Buyer / Seller Interaction Part Two
By James Gracey
     Successful Salespeople - Sell with Passion and Manage by Process - Prospecting - Securing the Interview
By James Gracey
     Successful Salespeople - Sell with Passion and Manage by Process - The Interview
By James Gracey

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?

More Evan Carmichael
More Information