Using labels in EXCEL 2007

[pcor]

I have app 400 names in Col B row 1 down to row 400 of my spreadsheet.
I would like to transfer that info to "paper labels"
Anyone know how?
Thanks

 

[DB.]

I have app 400 names in Col B row 1 down to row 400 of my spreadsheet.
I would like to transfer that info to "paper labels"

Anyone know how?
Thanks

You ask "Anyone know how" Of course someone here knows how!
I don't have your answer, but questions here rarely go without a
reply. The guys who resolve our problems here are the most talented and
helpful of any on any of the twelve newsgroups I visit.. I guess that
one of them will be along in a few minutes with a solution.

This gives me an opportunity to say "Thanks" to them.

 

[Gord Dibben]

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