How to Do a Mail Merge in Microsoft Word (with Pictures)

Table of contents:

How to Do a Mail Merge in Microsoft Word (with Pictures)
How to Do a Mail Merge in Microsoft Word (with Pictures)

Video: How to Do a Mail Merge in Microsoft Word (with Pictures)

Video: How to Do a Mail Merge in Microsoft Word (with Pictures)
Video: Is School Slowly Destroying Your Brain? 2024, November
Anonim

This wikiHow teaches you how to use the "Mail Merge" feature in Microsoft Word. The Mail Merge feature allows you to use a contact information sheet to automatically assign a different address, name, or information to each copy of a document. This feature is useful when you need to customize a newsletter or affidavit because you don't have to manually write each different name or address at the top of each document.

Step

Part 1 of 3: Creating a Contact Sheet

Mail Merge in Microsoft Word Step 1
Mail Merge in Microsoft Word Step 1

Step 1. Open Microsoft Excel

The Microsoft Excel application icon resembles a white “X” on a white background. After that, the " New " page will be displayed.

If you already have a contact sheet in Excel, skip to the step of loading or importing Excel contacts

Mail Merge in Microsoft Word Step 2
Mail Merge in Microsoft Word Step 2

Step 2. Click Blank workbook

It's in the upper-left corner of the “New” page. After that, a new Excel document will be opened.

Mail Merge in Microsoft Word Step 3
Mail Merge in Microsoft Word Step 3

Step 3. Add the contact header

Starting from the box A1 ” towards the right, enter a header or title as follows:

  • " FirstName " - The contact's first name needs to be entered in this field (box " A1 ”).
  • “LastName” – The last name of the contact needs to be entered in this field (box “ B1 ”).
  • ” Tel” – The contact phone number will be added in this field (box “ C1 ”).
  • ” StreetAddress” – The contact address needs to be entered in this field (box “ D1 ”).
  • “City” – The city of origin/residence of the contact needs to be added to this contact (box “ E1 ”).
  • “State” – The province of origin of the contact will be added in this column (box “ F1 ”).
  • “ZIP” – The postal code of the contact's residence needs to be added to this column (column “ G1 ”).
  • ” Email” – The email address of the contact will be entered in this field (box “ H1 ”).
Mail Merge in Microsoft Word Step 4
Mail Merge in Microsoft Word Step 4

Step 4. Enter the contact information

Starting at column A of box 2, enter the contact information for each person you want to add to the mail merge tool.

Make sure the information entered is accurate before you proceed to the next step

Mail Merge in Microsoft Word Step 5
Mail Merge in Microsoft Word Step 5

Step 5. Save the document

To save it:

  • Windows - Click “ File ", choose " Save As ", double click " This PC ”, select a file storage location on the left side of the window, type the document name in the " File name " field, and click " Save ”.
  • Mac - Click “ File ", choose " Save As… ”, enter the document name in the "Save As" field, select a storage location by clicking the "Where" box and selecting a folder, then click " Save ”.
  • Remember the location to save the selected file. You will then need to locate the Excel contact sheet at that location.
Mail Merge in Microsoft Word Step 6
Mail Merge in Microsoft Word Step 6

Step 6. Close the Excel window

Click the button X ” in the upper-right corner of the Excel window (Windows) or the red circle in the upper-left corner of the window (Mac). Now you can create or use the mail merge feature in Microsoft Word.

Part 2 of 3: Importing Contacts to Word

Mail Merge in Microsoft Word Step 7
Mail Merge in Microsoft Word Step 7

Step 1. Open Microsoft Word

The Microsoft Word application icon looks like a white “W” on a dark blue background. As in Microsoft Excel, the " New " page will be displayed after the program is opened.

If you already have a Microsoft Word document that you want to add contacts from Excel to, you will need to double-click the document to open it. Skip the next step if you already have a custom document

Mail Merge in Microsoft Word Step 8
Mail Merge in Microsoft Word Step 8

Step 2. Click Blank document

It's a white box in the upper-left corner of the page. After that, a blank Microsoft Word document will be displayed.

Mail Merge in Microsoft Word Step 9
Mail Merge in Microsoft Word Step 9

Step 3. Click the Mailings tab

This tab is at the top of the Microsoft Word window. After that, the toolbar will appear just below the row of tabs.

Mail Merge in Microsoft Word Step 10
Mail Merge in Microsoft Word Step 10

Step 4. Click Select Recipients

It's in the "Start Mail Merge" section of the toolbar " Mailings " After that, a drop-down menu will be displayed.

Mail Merge in Microsoft Word Step 11
Mail Merge in Microsoft Word Step 11

Step 5. Click Use an Existing List…

This option is in the drop-down menu. After that, a new window will open.

  • If you want to use contacts from Outlook, you can select the option “ Choose from Outlook Contacts ” from the drop-down menu.
  • You can also type a temporary list of contact information in Word by selecting “ Type a New List " This feature is useful when you only need to create some contact information.
Mail Merge in Microsoft Word Step 12
Mail Merge in Microsoft Word Step 12

Step 6. Select the Microsoft Excel contact sheet

On the left side of the window, click the folder that contains the Excel contact sheet. After that, click on the Excel sheet to select it.

Mail Merge in Microsoft Word Step 13
Mail Merge in Microsoft Word Step 13

Step 7. Click Open

It's in the lower-right corner of the window.

Mail Merge in Microsoft Word Step 14
Mail Merge in Microsoft Word Step 14

Step 8. Confirm your selection

Click the Excel sheet name in the pop-up window, then click the “ OK ” which is under the window. Your Excel sheet will be selected as the contact source location.

Make sure the " First row of data contains column headers " checkbox at the bottom of the window is checked

Part 3 of 3: Using the Mail Merge Feature

Mail Merge in Microsoft Word Step 15
Mail Merge in Microsoft Word Step 15

Step 1. Go to the place or point where you want to insert contact information

Find the place where you want to add contact information (eg the head of the document) and click on it to place the cursor.

Mail Merge in Microsoft Word Step 16
Mail Merge in Microsoft Word Step 16

Step 2. Click Insert Merge Field

This option is in the “Write & Insert Fields” section of the “ Mailings " After that, a drop-down menu will be displayed.

You may need to click on the tab “ Mailings ” one more time before following this step.

Mail Merge in Microsoft Word Step 17
Mail Merge in Microsoft Word Step 17

Step 3. Select the type of information

On the drop-down menu, click the name of one of the headings or headings of information from the Excel document to insert it into the Word document.

For example, if you want to add a contact's first name tag, click “ FirstName ” in the drop-down menu.

Mail Merge in Microsoft Word Step 18
Mail Merge in Microsoft Word Step 18

Step 4. Add other information if necessary

This information includes address, last name, contact phone number, etc.

Mail Merge in Microsoft Word Step 19
Mail Merge in Microsoft Word Step 19

Step 5. Click Finish & Merge

This button is at the far right of the tab toolbar. Mailings After that, a drop-down menu will be displayed.

Mail Merge in Microsoft Word Step 20
Mail Merge in Microsoft Word Step 20

Step 6. Determine the merging options

Click one of the following options:

  • Edit Individual Documents ” – This option will open each recipient document so you can readjust the document.
  • Print Documents… ” – This option allows you to print a copy of the document for each person listed on the contact sheet.
  • Send Email Messages… ” – This option allows you to send the document as an email. The contact's email address will be selected as the destination email address.
Mail Merge in Microsoft Word Step 21
Mail Merge in Microsoft Word Step 21

Step 7. Follow the instructions shown on the screen

You may have additional forms to review, depending on the options selected (e.g. if you select “ E-mail ”, you need to enter a title and click “ OK ). After that, the mail merging process is complete.

Tips

The mail merge feature is useful, especially when you create invoices, accounts, reports, and other bulk documents that need to be accompanied by names, addresses, and other personal information

Recommended: