mail merge
Microsoft Office Training verified by visa - mastercard securecode about microsoft training company london ukadd this page to your favourites/bookmarksAdd to favourites
view a printable version of this pagePrintable version
email this page to somebodyEmail this page
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Word Training and help » Mail merge

Mail merge

The UK's most regular instructor-led training courses.
Training information: microsoft word training courses · Microsoft word training courses london · Microsoft word training london

resolvedResolved · Low Priority · Version 2003

Mail merge

Michelle has attended:
Word Advanced course
Excel Intermediate course

by - delegate Michelle [2 posts] (2008 Jul 4 Fri, 16:40) replyReply

How do you chose the size of the labels

Word Advanced 1 day course
Version Date Location Places
available
Book Next place rate:
Card Invoice
2007 2008 Dec 12 Fri Bloomsbury 1 book now £240 £245
2003 2008 Dec 22 Mon Bloomsbury 4 book now £224 £235
2003 2009 Jan 23 Fri Bloomsbury 6 book now £195 £224
2003 2009 Feb 10 Tue Bloomsbury 6 book now £185 £224
2007 2009 Feb 12 Thu Bloomsbury 3 book now £240 £245
2003 2009 Mar 11 Wed Bloomsbury 6 book now £185 £224
Full Schedule: See all 18 Word Advanced course dates.
Bookings currently available until 11th November 2009.

RE: Mail merge

by - trainer Pete platinum contributer[799 posts] (2008 Jul 16 Wed, 14:34) replyReply

Hi Michelle,

Thank you for your post and welcome to the forum,
In answer to your question:

To create a single page of labels which are identical;

Create a new blank document,
Click Tools>Letters and Mailings
Select Envelopes and Labels
In the dialog box choose Labels
Type in the address you wish to have printed
Select Full Page of the Same Label
From the Options button choose your label type
Press Print and your full page of labels will be produced

Mail Merge Labels:
Create a new blank document
Click Tools> Letters and Mailings>Mail Merge...
Your Task Pane will appear on the right-hand side of the screen, displaying the Mail Merge Wizard


To create the Labels:
Under the heading Select document type, choose Labels
At the bottom on the Task Pane, click Next: Starting document
Under the Select starting document heading, ensure Change document layout is selecte
Under the Change document layout heading, click Label options...
Select the label you are using in the Label Options dialog box.

Note: Start by selecting the brand of label you are using, remembering to select A4 sizes if available. Then select the product code of the label you are using, usually found on the box or the side of the label sheet.
Click OK
If a warning appears, click OK
Click Next: Select recipients at the bottom of the task pane
Select the list for your labels under the Select Recipients heading
a. To use an Excel list, select Use an existing list
b. To use your Outlook contacts, choose Select from Outlook contacts

To use an Excel list:
Under the heading Use an existing list, click Browse...
In the Select Data Source dialog box, navigate to the file you want to use
In the Select Table dialog box, select the Excel worksheet that contains your data
Click OK

To use Outlook Contacts:
Under the heading Select from Outlook contacts, click Choose Contacts Folder
Select the Contact list you want to use
Click OK

To Setup the Labels:
When the Mail Merge Recipients dialog box appears, click OK
Click Next: Arrange your labels
Select how you want to add your information to the label. If you are using Outlook Contacts and would like to create Address Labels, the Address block... option might be the best choice. The option which most closely resembles Word 2000 is More Items...

Arranging labels using the Address block option
Click on Address block... under the Arrange your labels heading
Select options in the Insert Address Block dialog box to determine how you want your labels to appear
If you are using the Address Block option with a data source other than Outlook Contacts, it is recommended that you click on the Match Fields... button at the bottom of the dialog box. This will allow you to ensure that the fields in your data source match with the fields Word is expecting in order to complete the address block.
Click on OK until all dialog boxes are closed.

Arranging labels using the More Items option
Click on the More Items... option under the Arrange your labels heading
Ensure that the Database Fields option is selected
For each field you would like included on your label:
Click once to select the field
Click on the Insert button
Note: The fields will be entered onto the label in the order you select and insert them. They will be added without any spaces or line breaks - these can be added in once all the fields have been added to the label
When all fields have been added to the label, click the Close button
Add spaces and line breaks between the fields on your label by clicking between the field names and using the spacebar or Enter key

Copying your label layout to all labels
When you have decided on the label layout, click Update all labels to copy the layout to all other labels
Note: If you are unsure how your labels will appear, choose Next: Preview your labels at the bottom of the Task Pane to check them. If you want to make any changes, you can then choose Previous: Arrange your labels
Click Next: Preview your labels
Preview your labels. Use Previous: Arrange your labels at the bottom of the screen if you need to make adjustments

To complete the Merge:
Click Next: Complete the merge
Select your merge option:
a. Print... will send the labels directly to the printer
b. Edit individual labels... will create a separate document of labels, which you can edit, save and print

Don't forget to save your mail merge document. This will allow you to create the labels again without having to repeat all the steps above

regards Pete


Related articles

· Students and Microsoft Word
· Microsoft Word and its Uses in the Home
· Microsoft Word Editing Tips
· Five Time Saving Microsoft Word Tips
· Microsoft Word Cheat Sheet: Tips and Shortcuts

Please browse our web site to find out more about
microsoft word training courses and other Microsoft training courses.

Word tip:

Edit text in Print Preview

If you go into print preview and click on the page you will zoom into the text. If you need to make changes and don't want to come out of print preview, then deselect the magnifer (sencond button in -next to the print button)and click on the document. You will now be able to type and edit the document.

View all Word hints and tips

Rate this page:
3.5/5 (2 votes cast)
Institute of IT Training - Accredited Training Provider Microsoft Certified Partner
microsoft office
Microsoft Office Specialist Authorised Testing Centre (MOS and MCAS)

Prodigy Platinum Learning Partner

Institute of IT Training - Accredited Training Provider Association of Computer Trainers Valid HTML 4.01 Transitional
Valid CSS Markup

secure online payments - visa - mastercard

Mini sitemap. These are the main areas of our web site. Full sitemap.

Training by application Main information pages See also

Access courses
DreamWeaver courses
Excel courses
MS Project courses
Outlook courses
PowerPoint courses
VBA courses
Word courses
(more...)

Public scheduled courses
On-site training
Closed company courses

Microsoft Office training
Pricing and availability
Training schedule
Training venues

Access training
Dreamweaver training
Excel training
MS Project training
PowerPoint training

London Computer Training
Computer Training London

Microsoft Access training
Microsoft Excel training
Microsoft Project training
Microsoft Outlook training
Microsoft Powerpoint training
Microsoft Word training

Time Management Course London

Interested in Access training? Please see the following pages:
microsoft access courses · microsoft training access course
microsoft+access+training · access courses in london

Training Information

Training Articles

AddThis Social Bookmark Button What's this?
Add to Del.icio.us Add to Facebook Add to Digg Add to Reddit Add to Google Add to Yahoo Add to Diigo Add to Mr. Wong Add to Linkarena Add to Power Oldie Add to Folkd Add to Jumptags Add to Upchuckr Add to Simpy Add to StumbleUpon Add to Slashdot Add to Netscape Add to Furl Add to Spurl Add to Blinklist Add to Blogmarks Add to Technorati Add to Newsvine Add to Blinkbits Add to Ma.Gnolia Add to Smarking Add to Netvouz