- Click the Mailings tab.
- Click the Start Mail Merge button.
- Select Step-by-Step Mail Merge Wizard.
The Mail Merge pane appears on the right, ready to walk you through the mail merge.
- Select a type of document to create.
- Click Next: Starting document.
- Choose a document to start with.
You can either use the current document, select a template, or pick an existing document for your mail merge.
- Click Next: Select recipients to continue.
- Choose a document to start with.
You can either use the current document, select a template, or pick an existing document for your mail merge.
- Click Next: Select recipients to continue.
- Select your data file.
Your mail merge recipients can come from various data files, such as a database, Excel spreadsheet, Word document, or other file types.
- Click Open.
The Mail Merge Recipients dialog box will show the addresses from your data file. If you’re using an Excel file, you might also need to choose the specific worksheet containing the addresses.
- If there’s an address you don’t want to include, simply uncheck it.
- Make sure the right recipients are selected and click OK.
- Click Next: Write your letter.
Write Your Letter
Once your main document is ready and you’ve connected and edited your recipient list, you can start adding merge fields. These fields act as placeholders for unique information, like names or addresses, from your recipient list.
When you insert a merge field into the document, it will pull the specific information for each recipient.
- Click where you want to add the information.
- Choose one of the placeholder options.
You can insert merge fields either from the wizard or from the Write & Insert Fields group on the ribbon:
- Address Block: Inserts names and addresses of the recipients.
- Greeting Line: Inserts the recipient’s name in the greeting line.
- Insert Merge Field: Click this to see a list of other fields you can insert.
Customize the Placeholder
- After selecting your placeholder, click OK.
- (Optional) Repeat these steps to add any other merge fields you want in the document.
- Click Next: Preview your letters to continue.
Preview Your Mail Merge
It’s helpful to see how the actual data will look in your document instead of just viewing the merge field names. Previewing ensures everything appears as you want before completing the mail merge.
- Use the arrow buttons in the Mail Merge pane to preview each merged document. You can also use the arrow buttons in the Preview Results group on the ribbon.
- To find a specific recipient, click Find Recipient in the Preview Results group or in the Mail Merge pane.
- Click Next: Complete the merge to move on.
Complete the Merge
After adding your recipient list and inserting merge fields into the document, the final step is to create a separate version for each recipient.
You have two ways to finish the mail merge:
- Edit Individual Documents: Creates a new document with the merged data. You can edit, save, and print it just like any other document.
- Print Documents: Merges the records and sends them directly to the printer.
- Choose the option you want to finish the mail merge.
- You can also click the Finish & Merge button on the ribbon to select a merge option.
Additionally, you can decide which records to merge—either all, just the one currently displayed, or a specific range.
- Select the records you want to merge and click OK.
Unlock powerful features with a genuine Office 2021 Professional Plus Key – get the best deal at the lowest price today!