Anna has attended:
Upgrade to Office 2007 course
PowerPoint Intermediate Advanced course
Excel Intermediate course
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