Mail Merge Your Newsletter
Mail Merge Your Newsletter
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
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
 | |
 |
No article feedback found. |
| |
Leave Your Feedback |
 | |
| |||
Dianne CramptonDianne 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 RobeyStephanie 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. | |||
 | |
|  |
Subscribe to Donald's articles
 | |
|
|  |
 | |
|
| |
 | |||||||
|
 | ||
 |
||
 |
||
|
||
|
| ||
 |
| 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. |
|
|
 |
| Modeling the Masters: Learn the true secrets behind Walt Disney's business success factors & grow your company! Video produced by Phanta Media |
|
|
 |
"Learn straight from Evan how you can Make a Full Time Income (And More) from a Website"
Click Here To Learn More |
|
|
|
|
Get advice & tips from famous business owners, new articles by entrepreneur experts, my latest website updates, & special sneak peaks at what's to come!
|
|
|
 How To Double Your Business The Money Game New Sales Leadership Paradigm Small Business Financing Canadian Leadership |
|
 | ||
 |
Top 50 Political Blogs
Top Political Blogs of 2009 | |
 |
Top 50 Blogs For Startups
Top Blogs To Watch In 2008 | |
| ||
 | ||||
| ||||
|
| ||||
| ||||
|
|
|
|
|
||||||||||||
|
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!
|
|
|
| ||||||||||
|
| ||||||||||
|
|
||||||||||