Step Open the 'Tools' menu. Click 'Letters and Mailings' and then 'Mail Merge Wizard.' Step Under Document Type in the dialog box, select 'Labels.' Step Select 'Label Options' to open the Label Options dialog box. Select 'Avery Standard' from the Label Products drop-down menu. Then select '5160 - Address' in the Product Number menu box. Step Select 'Use an Existing List' under Select Recipients. Click 'Browse' and then navigate to the Excel file and click 'Open.' Step Select your table in the 'Select Table' dialog box. Check 'First row of data contains column headers' then 'OK.' Step Select the column titles from your Excel file that correspond with the Word identifiers in the Mail Merge Recipients dialog box. The labels in Word will use identifiers such as 'name' or 'address.'
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
May 2018
Categories |