HOW DO I MAKE ADDRESS LABELS OUT OF LIST IN EXCEL DOC?

[Guest]

i just exported a list of names and addresses for our new catalog, from
quickbooks into excel. i am trying to figure out how to convert this list
into address labels. the list is far too long to just copy and paste it over
to the address label template i have going (avery #5160 3x10 30 per page).
is there an easy way to do this? thanks in advance for any help you can give.

 

[Door]

You probably need to checkout MS Word and the 'Mail Merge', using th
Excel Worksheet as the input to a Mail Merge.

 

[David Biddulph]

i just exported a list of names and addresses for our new catalog, from
quickbooks into excel. i am trying to figure out how to convert this list
into address labels. the list is far too long to just copy and paste it
over
to the address label template i have going (avery #5160 3x10 30 per page).
is there an easy way to do this? thanks in advance for any help you can
give.

Use Mail Merge in Microsoft Word to import the data from Excel:

http://www.mvps.org/dmcritchie/excel/mailmerg.htm
http://office.microsoft.com/en-gb/assistance/HA011269731033.aspx

 

[Gord Dibben]

kristina

For help on Word mail merge using Excel as the data source.

http://www.mvps.org/dmcritchie/excel/mailmerg.htm

http://www.mvps.org/word/FAQs/MailMerge/CreateAMailMerge.htm

http://www.mvps.org/word/FAQs/MailMerge/CreateADataSource.htm

And a training tutorial for creating envelopes and labels.

http://office.microsoft.com/training/training.aspx?AssetID=RC01039029...


Gord Dibben Excel MVP

i just exported a list of names and addresses for our new catalog, from
quickbooks into excel. i am trying to figure out how to convert this list
into address labels. the list is far too long to just copy and paste it over
to the address label template i have going (avery #5160 3x10 30 per page).
is there an easy way to do this? thanks in advance for any help you can give.

Gord Dibben MS Excel MVP