Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

mail marge

ResolvedVersion 2007

Mail marge

I need to do a label mail merge using an excel spread sheet, I do not want to use all the fields on this spreadsheet either. Please help!

RE: Mail marge

Hello Anna

Thank you for your question.

You'll need to use the Mail Merge Wizard in Word to create your labels.

You'll need to use the Mailings tab, click the Start Mail Merge button, and select Step by Step Mail Merge Wizard.

The first two steps will ask you to select what you'd like to create (labels) and select your starting document and label type.

At step 3, browse to and select the spreadsheet containing your data.

At step 4, select More items. A list of the headings/fields from your spreadsheet should appear and you can select and insert just the ones that are required.

Follow through the remainder of the steps (5 and 6).

Hope this works ok, let me know if you have any problems.

Kind regards
Amanda

Mon 13 Apr 2009: Automatically marked as resolved.

Excel tip:

Page Break Preview in Excel 2010 (Hint/tip)

If you select View then Workbook Views then Page Break Preview, you will be able to view how your Excel spreadsheet will be split across multiple pages when printed. Even better, you can also drag a page break to a new place. Excel will then scale down your entire worksheet to fit the information you want on the pages you want.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.