Custom Labels

[Sandy]

Is there a way to create labels in Excel using Avery labels? I've tried to
make the rows and columns the same size as the labels but it still wont print
correctly?

 

[Gord Dibben]

Sandy

You have replies to the same question you posted earlier.

Excel alone is poorly suited for creating labels.

Do you have Word?

Use Word's mailmerge with Excel or Access as the data source.

Assuming you are using Word for the mailmerge and Excel for the source see
these sites for help.

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


Gord Dibben MS Excel MVP

 

[Peter]

Is there a way to create labels in Excel using Avery labels? I've tried to
make the rows and columns the same size as the labels but it still wont print
correctly?
If you display rulers and set the margins correctly, it should work, but why not use the preset templates in Word? These allow you to enter the 4 digit number code from the Avery product, and print directly onto it. You can always do a mail merge from Excel into the Word doc if cutting and pasting into a table in Word does not work.