Using document merge to simplify routine work
To merge a document with an Excel table, do the following:
1. Open the document, in which you want to insert different attributes.
2. On the Mailings tab, in the Start Mail Merge group, select Start Mail Merge and then choose Step by Step Mail Merge Wizard...:
3. In the Mail Merge pane, choose the document type and then click Next.
4. Select the starting document type and then click Next.
5. In the Step 3 of Mail Merge Wizard:
5.1. Select recipients, for example, from existing list, then click Browse... to open the file:
5.2. In the Select Data Source dialog box, choose the file which contain data and click Open.
5.3. In the Select Table dialog box, select the table by double-click in it or by highlighting it and clicking OK:
5.4. In the Mail Merge Recipients dialog box, click OK to merge table:
5.5. Click Next in the Step 3 of Mail Merge pane.
6. In the Step 4 of Mail Merge Wizard:
6.1. Select Address block... to open the Insert Address Block dialog box:
Using checkboxes and radio buttons, choose how you want to see an address block and click the Match Fields....
Change the match fields, if necessary, and then click OK twice.
6.2. Select More items... to open the Insert Merge Field dialog box:
Select which field you want to insert and click Insert.
7. After you click Next, you can see the merge data: to open the Insert Merge Field dialog box:
Here you can watch and, if it is necessary, change any information.
8. In Step 6 of Mail Marge, you can print or edit individual letters: