Outlook/mail merge for labels

  Cara2 22 Nov 11
Locked

Am following step by step wizard, starting from Word 2007, using Mail Merge wizard and data from my Contacts list.

Can follow steps, but must be omitting a stage as when I merge as the pages are blank.

Anything obvious spring to mind? I am really irritated with myself repeating the process but ending up with a blank page!

  Woolwell 22 Nov 11

Have you clicked on update labels?

  Cara2 22 Nov 11

Previous to 'update labels' I have two lines of data, 2nd line is home address. At this point the full name and address is not shown.

Then I press 'update lables' - label reverts to one line of data.

Preview lables shows no data at all?

  Woolwell 22 Nov 11

I suspect that you need to go back to the data source stage. When selecting Outlook contacts did you also choose the contacts folder?

  Cara2 22 Nov 11

Yes, have selected contact folder. At this stage all contacts are displayed and I choose a field to include. The full name and address are displayed.

I get to the stage where 'Next Record' and 'Address Block' are shown, then I press update all lables. 'Address Block' disappears and thereafter no names and addresses are shown.

At this stage it would have been faster to handwrite all the labels!

  Woolwell 22 Nov 11

I cannot replicate that. However in the back of my mind is a problem I had that was not too different to yours and as a long shot try on the View tab choosing web layout and see if the address block appears and then go back to print layout.

  Woolwell 22 Nov 11

I cannot replicate that. However in the back of my mind is a problem I had that was not too different to yours and as a long shot try on the View tab choosing web layout and see if the address block appears and then go back to print layout.

  Woolwell 22 Nov 11

Sorry about the double post - no idea how that happened.

  Taff™ 22 Nov 11

Instead of choosing address block put in the fields for first name, surname and then a line break followed by address line 1, address line 2 etc. Then press the update labels button. It also helps to Preview results before going to the merge.

  Cara2 22 Nov 11

Thanks for suggestions - I will give it a go.

  lotvic 23 Nov 11

If it helps this is how I do it in Word 2003. I have the Mail Merge toolbar showing and click on:

'Main document setup' | 'Open Data Source' | 'Mail Merge Recipients' | 'Insert Address Block' popup box and click on 'Match Fields' at bottom and choose the fields you want | 'View Merged Data' (this will only show record 1 in top left label) | 'Propagate Labels' (which fills sheet 1, section 1) | Click on 'Merge to New Document' and in the pop up box choose 'All'

A new Window opens with a new document created showing ALL the names and addresses. New document shows at bottom as Page 1, Sec 1, 1/4 (or however many sections are needed for the number of sheets of labels you need - each section is a separate page of labels)

I can now save my new document as an ordinary word .doc and print them whenever I want.

I don't bother saving the 1st document that I did all the planning on as I now have the label sheets that I wanted.

Advertisement

This thread is now locked and can not be replied to.

Windows 10 Home vs Windows 10 Pro comparison: Here are the extra features you get in the Pro version

Why Formula-e needs to go faster

How Instagram spots trends

How to use Apple Music in the UK: Complete guide to Apple Music's features

We use cookies to provide you with a better experience. If you continue to use this site, we'll assume you're happy with this. Alternatively, click here to find out how to manage these cookies

hide cookie message