98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Mail marge
Mail marge
Resolved · Low Priority · Version 2007
Mon 6 Apr 2009, 14:00Delegate Anna said...
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!
Mon 6 Apr 2009, 16:05Trainer Amanda said...
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.
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:Checking formulas with multiple operatorsWhen dealing with formulas containing more than one operator (+, -, /, *), Excel follow standard BEDMAS order of operation rules. These rules specify the order that calculations will be performed in, regardless of how the formula reads left to right: |
