98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » excel+training - Mail Merge
excel+training - Mail Merge
Resolved · Low Priority · Version Standard
Kate has attended:
Excel Intermediate course
Mail Merge
If I set up addresses on a excel spreadsheet, how can I merge them to form labels?
RE: 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
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Transpose textYou can transpose any range of cells, turning the columns into rows and the rows into columns. Just follow these steps: |