Learn how to use Word’s mail merge commands to personalize and customize mailing labels, email messages, and more!
Just in time for those holiday greetings!
Save time! Stop typing personalized correspondence one at a time.
Did you know you can:
- Create personalized email messages and include an attachment?
- Separate documents or PDFs for each recipient during a single merge?
- Filter your database and create mailing labels for select recipients?
- Create a template once and use it as many times as you want?
- Produce a directory of contacts you can print or format as a PDF?
Whether you’re using an Excel spreadsheet, a Word table, or Outlook contacts, I will show you step by step how to set up, filter, and perform a mail merge.
Click here for details on this Mail Merge Webinar!
A financial planner sent me a letter that went into the trash the instant I opened it…without even blinking. Here’s why:
The letter was typed using the Comic Sans typeface. The typeface you select for your business correspondence should reflect the type of business you’re in. If you’re running a daycare center, a playful font like Comic Sans would be appropriate, but not for a financial planner who wants to be taken seriously.
She started the letter using “Dear Peggy.” Since I don’t know her, the planner should have addressed the letter with “Dear Ms. Duncan.” If we had met in passing or had talked on the phone at least once, or had our paths crossed at all, Dear Peggy would have been OK.
The signature was wrong. Real wrong. The financial planner was asking for my business and sent me a letter with a TYPED SIGNATURE! She didn’t even bother to sign her name! Never do this…regardless of how fancy the typeface is!
If you’re sending someone a form letter that you’re creating using mail merge, or you’re having something printed requiring your signature, do this instead of typing your signature:
Sign your name as you normally would on a blank sheet of paper using a fluid writing instrument so the signature will be smooth and solid.
Take a digital picture or scan it (if you need to scan and don’t have a scanner, someone you know does or perhaps your local office supply store or copy center…don’t buy one because you’ll probably rarely use it).
Save your scanned signature as a graphic as you would any item. (I also saved this graphic as an AutoText entry in Word so anytime I need it, I type the name I gave it and press F3.)
Create your mail merge letter as you normally would, and insert the graphic signature into the letter where you would normally sign it. Resize the graphic if you need to.
Run your mail merge. Your original-looking signature will print out on every letter.
Direct mail experts say that a signature signed in blue ink has a better response rate (I don’t remember why but I think it’s to show it’s an original). So if you’re sending out a direct mail letter and you have a color printer, sign your name in blue ink and scan using the color option.
Peggy Duncan, Time Management Expert