![]() Hi Guys I currently have an excel spreadsheet which populates some data into a Word Mail Merge Document.See how to prepare an Excel sheet for merge and how to correctly mail merge with dates Save the document by click File ( Office button) > Save. This tutorial explains how to do a mail merge from Excel to Word step-by-step. Click Preview Results in Preview Results group, then the labels are created. Click Update Labels in the Write & Insert Fields group under Mailings tab. Repeat step 7 to insert all the information you need, see screenshot: Put the cursor at the start of the document and click Mailing > Insert Merge Field, then select the information you want to be included in the labels. Then delete all 《Next Record》in the document, see screenshots: If the list you need to import is in an Excel workbook, there will be a Select Table dialog popping up after you selecting the workbook and clicking Open button. In the Select Data Source, select the file and click OK. Click Mailings > Select Recipients, select the option for your needs. Then click Home > Show/Hide Editing Marks for more convenient to edit the labels. In the Label Options dialog box, next to Label. On the Mailings tab, click Start Mail Merge > Labels. Step 1: Set up a document to match your labels. ![]() In the Label Options dialog, select North American Size from the Product number list. Creating labels with mail merge is a four-step process: set up a document to match your labels, connect to your spreadsheet, format the merge fields, and then print your labels. ![]() Open a new Word document, and click Mailings > Stat Mail Merge > Labels.
0 Comments
Leave a Reply. |