excel+training - Mail Merge

Hi Kate, Thank you for your post, to answer your question; if you use Microsoft Word to create your merged labels, follow the Mail Merge options as follows:
1. Open Microsoft Word, on a blank page use the Menu command Tools, Letters and Mailings, select the option Mail Merge.
2. From the Task Pane choose Labels, click; Next:Starting document,
3. Click the choice Label options, and from the dialog box choose your label size. Click OK.
4. Click Next: Select Recipients.
5. Choose; Use an existing list and click the Browse option, navigate to your chosen Excel workbook and click a dialog box will open offering spreadsheet options, click on your chosen sheet and click OK
6. From the next dialog box choose your criteria and click OK
7. Click Next: Arrange your labels
8. Click the More Items link to insert your required fields
9. Edit the entries to place them in Address format
10. Click Update all labels
11. Click Complete the merge
View and print your labels
I hope that helps, best regards Pete