Microsoft Office TrainingThe UK's Number 1 for Microsoft Office Training Sitemap add this page to your favourites/bookmarksBookmark page
 
view a printable version of this pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

articleYou've Got Mail Merge

It's 4pm. It's Friday. You've got the weekend on your mind and all you can think about is finishing off your work and hitting Shut Down. But just when you get ready to switch off, you're asked to get 200 personal mail outs to every employee. Unlike you, the internal post left the building 30 minutes earlier. What are you going to do? Well, how about sending everyone a personal email using Mail Merge?

Using Mail Merge allows you to create one document for every addressee. And by adding placeholders for information that has to be unique to an individual piece of mail, Microsoft Word 2007 is just the program for the job. Sit back and let Word put the care into carefree.

There are some basic elements required in any Mail Merge: the document you need to send; and the details of the addressee the information will be sent to. The main document, for example a letter or an email, could contain information which you are sending to everyone - a blanket letter. The unique information could be the recipient's address and the name that needs to appear after the greeting script.

Recipient information is usually stored in a central data source. A data source could be your Microsoft Office Outlook contacts' list, or a Word table, or an Excel worksheet. This information is generally listed in columns and rows. The data source information needs to be structured in a way that makes it possible to link specific information with the placeholders - or points where the unique information has to be inserted - in the main document.

In a mass mailing, the fields you use are called merge fields, and they are the placeholders for the unique information that comes directly from a recipient list.

Now, using Start Merge in the Mailings tab on the Ribbon, you can follow a step-by-step guide through your Mail Merge including how to set up the main document. To connect to the recipient list, in this example, it's easy to select the information from the specific Contacts' Folder in your Microsoft Office Outlook program. Mail Merge offers further options such as selecting specific recipients - all of which are also easy to follow.

After arranging the main document, which should include information that will be the same for each letter or email, along with the unique information (personal details such as name and address), you can preview how the merged information will look. Again the wizard will help guide you through each step with prompts and opportunities to edit or amend any of the information and recipient lists. Now, after a final review, you can get ready to print or send your email electronically. If your task is not urgent, you can save the data, including the information the main document is linked to for the mail out, for another time.

To really get to grips with those last minute mail out requests, find out much more about using Microsoft Word 2007 Mail Merge and spend some time on enrolling on a recognised training course.

Author is a freelance copywriter. For more information on word courses, please visit http://www.microsofttraining.net


Original article appears here:
http://www.microsofttraining.net/article-460-youve-got-mail-merge.html


Back to article list

Distribution notes

PUBLICATION GUIDELINES

  • You have permission to publish this article for free providing the "About the Author" box is included in its entirety.
  • Do not post/reprint this article in any site or publication that contains hate, violence, porn, warez, or supports illegal activity.
  • Do not use this article in violation of the US CAN-SPAM Act. If sent by email, this article must be delivered to opt-in subscribers only.
  • If you publish this article in a format that supports linking, please ensure that all URLs and email addresses are active links, without the rel='nofollow' tag.
  • Software Training London Ltd. owns this article. Please respect the author's copyright and above publication guidelines.
  • If you do not agree to these terms, please do not use this article.

Rate this page:
2.8/5 (129 votes cast)
Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses
Microsoft Certified Partner
Security Seal verified by visa, mastercard securecard

Mini sitemap. These are the main areas of our web site. Full sitemap.

Management training

Professional Skills courses
Project Management Course London
Project Management Courses London
Project Management Training London
Project Management Training
Project Seminar
Project Seminars
Time Management Course London
Time Management London
Time Management Courses London
Time Management Training London
Introduction to Finance course
Assertiveness Skills course
Effective Communications Skills training
Presentation Skills London

Training Formats

Public scheduled courses
On-site training
Closed company courses

Consultancy
Application Development

Blogs

Excel Training
MS Project Training
Microsoft Training Blog

Version differences

Office 2010 vs 2007
MS Project version differences

Training Information

London Computer Training
Computer Training London
Docklands Training Courses
Docklands Training London

Training venues London
Client list
FAQ
Pricing and availability
Course details / Syllabus

Training Articles
Training Information

Microsoft training

Microsoft Office training
& IT Applications

Microsoft Project training
Microsoft Outlook training
Microsoft Powerpoint training
Microsoft Word training
MS Project courses
MS Project training
Outlook courses
PowerPoint courses
PowerPoint training
VBA courses
Word courses
Microsoft.training
(more...)

Excel Training

Excel courses
Excel Training Courses Medway
Autonumber in Excel
Microsoft Excel training
Basic Excel Courses
Basic Excel Course
Basic Excel Training

Interested in MS Access training?

Access courses
Microsoft Access training
Microsoft access courses
Microsoft training access course
Microsoft+access+training
Access courses in london

Training provider

Training providers
IT training companies
IT training providers
Management Training providers
Management Training provider

Event history, feedback results
Events in 2012 · 2011 · 2010 · More

See also

Crystal Reports training