How to perform a mail merge with an Outlook Contacts list in Word (2024)

Summary

This article explains how to perform a mail merge with a Microsoft Outlook Contacts list in Microsoft Word.

Verify that contacts are displayed

To use the mail merge feature with an Outlook Contacts list, you must select the Show this folder as an e-mail Address Book check box in the Outlook Contacts Properties dialog box.

If no contact files are listed in Outlook, follow these steps:

  1. Right-click the contacts subfolder that is not being displayed, and then click Properties.

  2. On the Outlook Address Book tab, click to select the Show this folder as an e-mail Address Book check box, and then click OK.

For more information about how to start a mail merge from Microsoft Outlook, click the following article number to view the article in the Microsoft Knowledge Base:

287561 How to use the Mail Merge feature with contacts in Outlook 2002 and Outlook 2003

Mail merge with Outlook Contacts list

To perform a mail merge with an Outlook Contacts list in Word, follow these steps, as appropriate for the version of Word that you are running:

  1. Microsoft Word 2002

    On the Tools menu, click Letters and Mailings, and then click Mail Merge Wizard.

    Microsoft Office Word 2003

    On the Tools menu, click Letters and Mailings, and then click Mail Merge.

    Microsoft Office Word 2007

    On the Mailings tab, click Start Mail Merge, and then click Step by Step Mail Merge Wizard.

  2. In the Mail Merge task pane, click Letters under Select document type, and then click Next: Starting document.

  3. Use one of the following procedures:

    • If you want the want the body of the letter to be the document that is currently open, click Use the current document under
      Select starting document. Go to step 5.

    • If you want the want the body of the letter to be an existing template, click Start from a template under
      Select starting document, and then click Select template.

    • If you want the want the body of the letter to be an existing document, click Start from existing document under
      Select starting document. Click Open, and then select the file that you want to use as your main document.

  4. Click Next: Select recipients.

  5. Under Select recipients, click
    Select from Outlook contacts. Under Select from Outlook contacts, click Choose Contacts Folder.

  6. In the Select Contact List Folder dialog box, select the contact list that you want to use, and then click OK.

  7. In the Mail Merge Recipients dialog box, make any changes that you want, and then click OK.

  8. Click Next: Write your letter. Type your letter, if you have not already done so. Click where you want to insert the first field. In the Mail Merge task pane, click the field that you want to insert under Write your letter.

    Alternatively, click More Items to display the Insert Merge Field dialog box, and then insert the field that you want. When you have finished writing your letter and inserting merge fields, click
    Next: Preview your Letter.

  9. Click the left arrow or the right arrow to preview the way that the merged document will look for each recipient. Make any changes that you want. When you are finished, click Next: Complete the merge.

  10. Click Print.

References

For more information about mail merge, click the following article numbers to view the articles in the Microsoft Knowledge Base:

294684 How to use Mail Merge to create mailing labels in Word 2002

290408 Frequently asked questions about mail merge

294693 How to use mail merge to create a directory in Word 2002 and in later versions of Word

294685 How to use mail merge to create envelopes in Word 2002 and in later versions of Word

294694 How to use mail merge to create e-mail messages in Word 2002 and in later versions of Word

294695 How to use mail merge to create faxes in Word 2002 and in later versions of Word

294683 How to use mail merge to create form letters in Word 2002 and in later versions of Word

How to perform a mail merge with an Outlook Contacts list in Word (2024)

FAQs

How to perform a mail merge with an Outlook Contacts list in Word? ›

In Outlook, go to Contacts and select the names you want to include. Then go to Home > Mail Merge. Choose the options you want and then select OK.

How to do a mail merge from Outlook Contacts? ›

In Outlook, go to Contacts and select the names you want to include. Then go to Home > Mail Merge. Choose the options you want and then select OK.

How to do a mail merge in Word and Outlook? ›

Prepare Your Email Content in Microsoft Word
  1. Open Microsoft Word and select Blank document.
  2. Click the Mailings tab in the ribbon (menu bar).
  3. Click the Start Mail Merge button under the Mailings tab.
  4. Select E-mail Messages from the drop-down list.
  5. Type in the body of your email message in plain text format.
Jan 25, 2024

How would you import your Outlook Contacts for mail merge purpose? ›

• Choose from Outlook Contacts

Choose Filter Recipients to select the recipients you want to include. In the Query Options dialog box, next to List mail merge recipients by, choose Complete record. In the list of contacts, select the contacts you want to include in the mail merge, and then choose OK.

How do I merge Outlook Contacts into Excel? ›

Replies (1) 
  1. Select File.
  2. Select Open & Export > Import/Export.
  3. Select Export to a file > Next.
  4. Select Comma Separated Values > Next.
  5. Under the email account you want to export contacts from, select Contacts.
  6. Select Browse... and go to where you want to save your . ...
  7. Type in a file name and then select OK.
  8. Select Finish.
Aug 21, 2023

Can Microsoft Word perform mail merge? ›

When you use the Word Mail Merge feature, Word merges a main document with a recipient list to generate a set of output documents: The main document contains the basic text that is the same in all of the output documents.

How does Outlook mail merge work? ›

Mail merge lets you create a batch of documents that are personalized for each recipient. For example, a form letter might be personalized to address each recipient by name. A data source, like a list, spreadsheet, or database, is associated with the document.

Can mail merge be done in Word? ›

You start with a main document, attach a list of recipient information, and add mail merge fields. Then Word automatically fills in the fields with recipient information and generates all the individual documents.

How do I mail merge multiple recipients per email? ›

Add recipients directly to your message
  1. On your computer, open Gmail.
  2. At the top left, click Compose. ...
  3. In the "To:" line, add recipients.
  4. On the right of the "To:" line, click Use mail merge .
  5. Turn on Mail Merge.
  6. In your message, enter @.
  7. Select a merge tag: ...
  8. To insert the merge tag, press Enter.

What are the three main stages of mail merge? ›

The mail merging process generally requires the following steps: Creating a main document and the template. Creating a data source. Defining the merge fields in the main document.

What are the six steps of mail merge? ›

For example, the names and addresses of the recipients of a letter.
  • Mail Merge – Form Letters.
  • Step 1 – Select Document Type.
  • Step 2 – Select Starting Document.
  • Step 3 – Select Recipients.
  • Step 4 – Write Your Letter.
  • Step 5 – Preview Your Letters.
  • Step 6 – Complete the Merge.
  • Mail Merge – Labels.

How do I create a mail merge from Excel to Word? ›

How to mail merge from Excel to Word
  1. Create a Word document. ...
  2. Choose what kind of merge you want to run. ...
  3. Select the recipients. ...
  4. Connect Excel spreadsheet and Word document. ...
  5. Refine the recipient list. ...
  6. Add Address Block and Greeting Line. ...
  7. Insert merge fields. ...
  8. Preview the results.
Aug 24, 2023

How do I merge email labels from Excel to Word? ›

How to mail merge address labels from Excel
  1. Prepare Excel spreadsheet for mail merge. ...
  2. Set up mail merge document in Word. ...
  3. Connect to Excel mailing list. ...
  4. Select recipients for mail merge. ...
  5. Arrange layout of address labels. ...
  6. Preview mailing labels. ...
  7. Print address labels. ...
  8. Save labels for later use (optional)
Oct 21, 2023

How do I Import contacts from Excel to Word for labels? ›

Merge Excel to Word Labels

Find the Excel doc with your contact list and select it from the Select Data Source directory. Confirm that the source of your “merge” is your original contact list by clicking OK, and then click OK again to select the table with your contact list. Go back to the Mailings tab.

How do I merge Contacts to email? ›

Merge duplicate contacts
  1. Go to Google Contacts.
  2. At the top left, click Menu Merge & fix.
  3. If you don't find a "Merge duplicates" option, you don't have any contacts that you can merge. If you find contacts that you can merge: ...
  4. Optional: If you want to choose which contacts to merge: Go to Google Contacts.

How do I send bulk emails with individual names in Outlook? ›

How to send mass email in Outlook
  1. Step 1: Draft your message in Microsoft Word. ...
  2. Step 2: Start Mail Merge. ...
  3. Step 3: Select your email recipients. ...
  4. Step 4: Personalize your message. ...
  5. Step 5: Finish & Merge. ...
  6. Create professional-looking emails that match your brand. ...
  7. Save time on list management. ...
  8. Avoid email blacklists.
Jan 25, 2024

How to send email to multiple recipients in a list from Excel via Outlook? ›

How to send bulk emails from Outlook using Excel
  1. Step 1 – Get your spreadsheet ready. ...
  2. Step 2 – Create a message draft. ...
  3. Step 3 – Connect the Excel spreadsheet and the Word document. ...
  4. Step 4 – Personalize the email with merge fields. ...
  5. Step 5 – Merge and send off the emails.
Jan 25, 2024

How do I merge Contacts from different email accounts? ›

Go to your Gmail Settings page. Click Accounts and Import. In the Import mail and contacts section, click Import mail and contacts.

Top Articles
Latest Posts
Article information

Author: Lilliana Bartoletti

Last Updated:

Views: 6266

Rating: 4.2 / 5 (53 voted)

Reviews: 84% of readers found this page helpful

Author information

Name: Lilliana Bartoletti

Birthday: 1999-11-18

Address: 58866 Tricia Spurs, North Melvinberg, HI 91346-3774

Phone: +50616620367928

Job: Real-Estate Liaison

Hobby: Graffiti, Astronomy, Handball, Magic, Origami, Fashion, Foreign language learning

Introduction: My name is Lilliana Bartoletti, I am a adventurous, pleasant, shiny, beautiful, handsome, zealous, tasty person who loves writing and wants to share my knowledge and understanding with you.