Skip to content

TechRepublic

  • Top Products Lists
  • AI
  • Developer
  • Payroll
  • Security
  • Project Management
  • TechRepublic Academy
  • Innovation
  • Cheat Sheets
  • Cloud
  • 5G
  • Big Data
  • TechRepublic Premium
  • Top Products Lists
  • AI
  • Developer
  • Payroll
  • Security
  • Project Management
  • TechRepublic Academy
  • Innovation
  • Cheat Sheets
  • Cloud
  • 5G
  • Big Data
  • See All Topics
  • Sponsored
  • Newsletters
  • Forums
  • Resource Library
TechRepublic Premium
Join / Sign In
Software

Image: Save time with Microsoft Word’s Mail Merge feature

By Bill Detwiler March 16, 2006, 5:07 AM PST on Twitter billdetwiler

Image
1
of 17

Image: Save time with Microsoft Word’s Mail Merge feature

Let’s jump right in to creating a form letter so you can see how much time you could save with Word’s mail merge.rnTo get started, open a new document in Word and, from the menu bar, choose Tools | Letters and Mailings | Mail Merge. In the sidebar area, Word opens a Mail Merge helper that provides you with a wizard-like interface that walks you through the process.rn

rnWord’s mail merge can be used to create form letters, e-mail messages, envelopes, labels, or directories. With a little imagination, these choices let you create just about any kind of document or communication you would need.

Image: Save time with Microsoft Word’s Mail Merge feature

Any document you’ve created can be converted into a form letter. This starting document is often referred to as the “master document” as well. The terms are interchangeable, although other Word features also use the term “master document”, so be sure to keep things straight.rnThe starting document is the document that will ultimately contain the base form letter.

Image: Save time with Microsoft Word’s Mail Merge feature

In this step, you need to decide to which recipients you want to send the form letter. Word’s mail merge feature lets you use a wide variety of data sources. You can use an existing list you created for an old mail merge. Or, you can type in a new list of recipients. You can also use your Outlook address book if you like.

Image: Save time with Microsoft Word’s Mail Merge feature

If you select the “Type a new list” option Word also provides you with a “Create” option so that you can actually provide your data list.

Image: Save time with Microsoft Word’s Mail Merge feature

The New Address List form allows you to easily provide recipient information and includes all of the fields you would expect, including first name, last name, address information, e-mail address and phone numbers. If you need different information, such as an employee’s length of service or another piece of information not provided in the window, click the Customize button.

Image: Save time with Microsoft Word’s Mail Merge feature

When you’re done with a record, click the New Entry button to complete it. If you want to remove a record, choose Delete Entry. Once you get a lot of entries, you can use the Find Entry button to locate a specific record. Finally, you can also sort and filter you entries. For example, you can sort you entries by zip code, or filter the entries so that just records from a particular city are available. When you’re done adding entries, click the Close button.rnWord will ask you to save your new list so you can use it again. Provide a name for your list and click the Save button.

Image: Save time with Microsoft Word’s Mail Merge feature

With your list saved, Word gives you the opportunity to take a look at your list, sort it, filter it, and choose whether to include or exclude specific records.

Image: Save time with Microsoft Word’s Mail Merge feature

You can also filter records–that is, select just a certain subset of records to include in your output. For example, suppose you want to print form letters just for a particular zip code. Notice that each heading has a little down arrow right next to the name. Click the down arrow to get a list of all of the values in that column. When you select a specific value, you will only see records that have that value in that field. All other records are then hidden from view and will not be printed. To remove your filter, click the filter down arrow and choose the “(All)” option.

Image: Save time with Microsoft Word’s Mail Merge feature

When you’re done with your record manipulation, click the OK button. The right-hand sidebar now indicates which data file you’re using. Click the “Next: Write your letter” option to continue.

Image: Save time with Microsoft Word’s Mail Merge feature

Now, you need to type your letter. Or, if you’ve opted to use an existing letter, you need to provide Word with “fields” that are replaced with the information from your address list. Remember that each form letter will be addressed to a different person. So, you don’t want to type your letter to a specific individual, but want to make it generic and let Word do the heavy lifting for you.rnBefore you start typing, notice the addition of a new toolbar to your arsenal.

Image: Save time with Microsoft Word’s Mail Merge feature

Using the More items? link, you can include the merge fields you populated earlier.

Image: Save time with Microsoft Word’s Mail Merge feature

We’ll start simple. In your letter, type the word “Dear” and then hit the space bar. Now, click the More Items option. The Insert Merge Field window opens with the same list of fields you saw earlier. Choose the field you want to insert?in this case, the First Name field?and click the Insert button.

Image: Save time with Microsoft Word’s Mail Merge feature

In your document, you will get <>. The brackets around the field indicate to Word that this is a field and not straight text. So, each time Word sees this indicator, it will replace “<>” with information from your data table.

Image: Save time with Microsoft Word’s Mail Merge feature

All of the fields we want are on the letter.

Image: Save time with Microsoft Word’s Mail Merge feature

With your letter written, it’s time to see the results. From the sidebar, click the “Next: Preview your letters” option. The result should look similar to what you see here.

Image: Save time with Microsoft Word’s Mail Merge feature

Once you’re verified your recipients, click the “Next: Complete the merge” option.

At this point, Word has not officially performed the merge. That is, your letter and data file are still mostly separate. When you click one of the two options?(1) Print; or (2) Edit individual letters?Word asks you what you want to merge.

Image: Save time with Microsoft Word’s Mail Merge feature

Your options here are to merge all of your records, in which case you will get one page per recipient, or choose which records you want to include. When you choose the print option, Word sends your letter right to your printer.

  • Software
  • Account Information

    Share with Your Friends

    Image: Save time with Microsoft Word’s Mail Merge feature

    Your email has been sent

Share: Image: Save time with Microsoft Word's Mail Merge feature
Image of Bill Detwiler
By Bill Detwiler
Bill Detwiler is the Editor for Technical Content and Ecosystem at Celonis. He is the former Editor in Chief of TechRepublic and previous host of TechRepublic's Dynamic Developer podcast and Cracking Open, CNET and TechRepublic's popular online show.
  • Account Information

    Contact Bill Detwiler

    Your message has been sent

  • |
  • See all of Bill's content

TechRepublic Premium

  • TechRepublic Premium

    Office relocation checklist

    PURPOSE New office launches and site relocations run the range from straightforward to overly complex. For intricate, sophisticated new office deployments and larger site moves, TechRepublic Premium’s Office relocation checklist can help plan, monitor and execute such projects. From the checklist: LIST REQUIRED OF EQUIPMENT AND SERVICES Begin by creating a simple list of required ...

    Downloads
    Published:  May 25, 2023, 4:00 PM EDT Modified:  May 26, 2023, 11:17 AM EDT Read More See more TechRepublic Premium
  • TechRepublic Premium

    Onboarding and offboarding IT staff checklist

    PURPOSE Onboarding and offboarding employees requires careful attention. Otherwise, team members may receive insufficient permissions to perform their jobs or continue to have access long after their employment’s termination. Given the stakes, the problem is even worse when managing IT staff permissions, so it’s imperative that your company adopts a system to ensure consistency. Employees, ...

    Downloads
    Published:  May 24, 2023, 4:00 PM EDT Modified:  May 25, 2023, 9:19 AM EDT Read More See more TechRepublic Premium
  • TechRepublic Premium

    10 must-know Firefox tips

    PURPOSE TechRepublic Premium presents 10 tips for the Firefox open-source browser. Even if you only follow some of these, you’ll find your browser experience to be much improved. From the article: 1. USE CAUTION WITH ADD-ONS AND THEMES This is one of the first tips I always offer. I’ve seen web browsers with so many ...

    Downloads
    Published:  May 23, 2023, 4:00 PM EDT Modified:  May 24, 2023, 6:46 PM EDT Read More See more TechRepublic Premium
  • TechRepublic Premium

    Bring your own device policy

    PURPOSE The purpose of this Bring your own device policy from TechRepublic Premium is to provide requirements for BYOD usage and establish the steps that both users and the IT department should follow to initialize, support and remove devices from company access. These requirements must be followed as documented in order to protect company systems ...

    Downloads
    Published:  May 22, 2023, 4:00 PM EDT Modified:  May 23, 2023, 7:26 PM EDT Read More See more TechRepublic Premium

Services

  • About Us
  • Newsletters
  • RSS Feeds
  • Site Map
  • Site Help & Feedback
  • FAQ
  • Advertise
  • Do Not Sell My Information

Explore

  • Downloads
  • TechRepublic Forums
  • Meet the Team
  • TechRepublic Academy
  • TechRepublic Premium
  • Resource Library
  • Photos
  • Videos
  • TechRepublic
  • TechRepublic on Twitter
  • TechRepublic on Facebook
  • TechRepublic on LinkedIn
  • TechRepublic on Flipboard
© 2023 TechnologyAdvice. All rights reserved.
  • Privacy Policy
  • Terms of Use
  • Property of TechnologyAdvice