Run the Merge a few times to get the hang of it, and if you print the document of labels on a sheet of 8 1/2 x 11 paper, you can hold it up to the labels to see if the spacing works correctly, or not. The document of labels with your Clients should appear. If you want the names to appear as: Last, First and Middle Initial, key in a comma after the Last Name Merge field and a space before adding the First Name Merge field. In the Create Labels window, click: Insert Merge Field button to see your column headers.Īrrange the Merge fields to your preference, for example, if you want the Client Number at the top with a blank line before the Client name, press the Enter key twice. Select your Label preference and click: OK Select your Excel file and click: Open, you may need to change the Files of type to: All Files Tools > Mail Merge > Create button > Mailing Labels > Active Window > Get Data > Open Data Source Set up a Mail Merge in Word and use the Excel file as the source.
0 Comments
Leave a Reply. |