Shopping Cart
/ /

How to Perform a Mail Merge in Outlook from Excel

How to Perform a Mail Merge in Outlook from Excel




Mail merging in Microsoft Outlook is a powerful feature that allows you to send personalized emails to a list of recipients stored in an Excel spreadsheet. Whether you're sending newsletters, announcements, or personalized messages, this tutorial will guide you through the process step by step.


Step 1: Prepare Your Data in Excel


Before you can perform a mail merge in Outlook, your Excel data needs to be organized correctly:


- Create a header row with clear column labels (e.g., "First Name," "Last Name," "Email Address").

- Enter the recipient data in subsequent rows, ensuring each column contains the corresponding information.

我们将用于与 Outlook 进行邮件合并的 Excel 文件示例


Step 2: Launch Microsoft Word for Email Composition


  1. Open Microsoft Word.
  2. Click on "File" and select "Options."
  3. In the Word Options dialog box, click on "Add-Ins."
  4. In the "Add-Ins" section, select "COM Add-ins" from the drop-down menu and click "Go..."
  5. Check the box next to "Microsoft Office Mail Merge" and click "OK."
  6. Close and reopen Microsoft Word.


Step 3: Connect to Your Excel Data Source


  1. Click on the "Mailings" tab in the ribbon.
  2. Select "Start Mail Merge" and choose "Email Messages."

如何在 Word 中创建邮件合并文档

Step 4: Insert Merge Fields


  1. Place your cursor in the Word document where you want to insert a merge field.
  2. Click on "Insert Merge Field" in the "Mailings" tab.
  3. A list of fields from your Excel spreadsheet will appear. Select the field you want to insert (e.g., "First Name").
  4. Repeat this process for each field you want to include in your email (e.g., "Last Name," "Email Address").


Step 5: Complete the Mail Merge


  1. Click on "Select Recipients" in the "Mailings" tab and choose "Use an Existing List."将Excel工作表连接到单词
  2. Browse and select your Excel spreadsheet containing the recipient data.
  3. Verify that Word correctly identified the data source and sheet.
  4. Click "OK."


Step 6: Preview and Finish the Mail Merge


  1. Click "Preview Results" in the "Mailings" tab to ensure that the merge fields populate correctly.
  2. Review the preview to confirm that the email content appears as expected.确认格式,然后单击Excel中的确定
  3. Click "Finish & Merge" in the "Mailings" tab.
  4. Choose "Send Email Messages."
  5. In the "Merge to Email" dialog box:

   - Select the merge field for the "To:" field (usually the email address).

   - Click "OK."


Step 7: Complete the Email Merge in Outlook


  1. Outlook will open, and a "Mail Merge" dialog box will appear.
  2. Ensure that "HTML" is selected as the email format.
  3. Click "OK" to start the email merge process.




Performing a mail merge in Outlook from an Excel spreadsheet can save you time and effort when sending personalized emails to a list of recipients. Follow the steps outlined in this tutorial to create and send customized emails efficiently. With this skill, you can effectively communicate with your contacts while maintaining a personal touch.