excel+training - mail merge
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel+training - Mail Merge

excel+training - Mail Merge

resolvedResolved · Low Priority · Version Standard

replyReply Tue 11 Dec 2007, 15:57Delegate Kate said...

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?

For upcoming training course dates see: Pricing & availability

replyReply Fri 14 Dec 2007, 11:33Trainer Pete said...

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

 

Excel tip:

Recovering Unsaved Work in Excel 2010

Ever closed your Excel workbook in a hurry without saving your work beforehand? Here's how to get it back.

Choose File then Info, click Manage Versions and then Recover Unsaved Workbooks which will automatically find the spreadsheets that haven't been saved.

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard