Browse » Home
Sunday, March 17, 2013
How to Convert Labels to Avery 5160
1. Open Word 2010 and select the 'Mailing' tab. Click the 'Start Mail Merge' wizard. Click 'Labels.' The label dialog box appears. Select 'Avery' in the vendor list and locate the 5160 labels. Click 'OK.'
2. Click the 'Select Recipients' button. Select 'Use Existing List.' Browse the computer and locate the Excel workbook containing the label information. Select the workbook and click the 'Open' button. The table dialog box appears. Select the worksheet that contains the label data. Click 'OK.'
3. Click the 'Insert Mail Merge' button. A drop-down list appears. Select a field from the list. Click the 'Preview Results' button to preview the label changes. Click 'Update Labels' to apply the new changes to all of the labels.
4. Click 'Finish Merge' to finalize the mail merge process. Select 'Edit Individual Documents.' Click 'All.'