Printing Address Labels

  Granddad Ray 14:08 28 Nov 2006

For many years now I have printed address labels in sequence on sheets of labels for my Christmas cards from an Excel database. My problem is that I have simply forgotten how to do it. Can anybody help and aging old fart

  Jackcoms 14:11 28 Nov 2006

Possibly by having each address in a different cell in an Excel worksheet and then printing the entire worksheet??

  VoG II 14:15 28 Nov 2006

Did you use Mail Merge in Word, using the Excel file as the Data Source?

  brambles 15:21 28 Nov 2006

In Word Tools > Mail Merge
Create - select Mailing Labels from available drop down list.
Get Data - Open Data Source - now as VoG™ suggests you might - you want file Type MS Excel Worksheets - select the file containing the database.
Setup main document OK
Select label size OK
Insert merge fields ---it will all come back to you.

When you have a fully merged label print on the screen ready for printing ..Save it as Xmas 2006 labels.

  Granddad Ray 15:31 28 Nov 2006

Tried to use Mail Merge but I could not get it to recognise an Excel file as the source. Obviously I'm doing something wrong. Can I have step by step instructions?

  shellship 15:41 28 Nov 2006

I'm a granddad, too, but I have used a bit of software - Avery Design Pro (and its predecessor) - for years for my Christmas cards and you can add pretty pictures to the labels too.

  Granddad Ray 16:06 28 Nov 2006

Thanks to you all. Job Now done

  TheWhiteSeal 11:32 09 May 2008

Hi there,

On the subject of address labels, i never really had much look getting my label printer to print them. I seemed to spend more time messing around with the printer than getting the address labels to print. In the end i decided to give up on the whole DIY approach and i got a british labels company to print my <a href="click here">address labels</a> instead.

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

Elsewhere on IDG sites

Dell XPS 13 9370 (2018) review

HomePod review

Comment regarder les Oscars 2018 ?