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

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.

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

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


kristina Wrote:
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
------------------------------------------------------------------------
Door's Profile: http://www.excelforum.com/member.php...o&userid=33068
View this thread: http://www.excelforum.com/showthread...hreadid=528920

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

"kristina" wrote in message
...
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/as...269731033.aspx
--
David Biddulph

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

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/MailMe...AMailMerge.htm

http://www.mvps.org/word/FAQs/MailMe...DataSource.htm

And a training tutorial for creating envelopes and labels.

http://office.microsoft.com/training...tID=RC01039029...


Gord Dibben Excel MVP

On Sat, 1 Apr 2006 15:45:01 -0800, kristina
wrote:

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