Converting Excel to Labels

Question

I am trying to make labels. I have put all the data into an excel spreadsheet. How do I take the data i have inputted and make it easy to cahnge into labels.

Answer 1

Hi,

The easy way if you have your names and addresses in Excel, is to use Word.

Go to Tools/Letters and Mailings.

Use your Excel file as the data source.

Answer 2

Saved from a previous post:

Lots of times, it's easier to use MSWord for printing and Excel (or some other

database application) as the source.

You may want to read some tips for mailmerge.

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

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

The first is from David McRitchie and the second is by Beth Melton and Dave

Rado.

And if you notice problems with the formatting of data (like zipcodes)...

Debra Dalgleish posted this:

There's an article on the Microsoft web site that might help you:

Answer Box: Numbers don't merge right in Word

   http://office.microsoft.com/en-ca/assistance/HA011164951033.aspx

And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill

has instructions here:

   http://sbarnhill.mvps.org/WordFAQs/CustomizingWord2002.htm

about half way down the page.

==========

I often cheat instead of racking my brain.

I'll insert another column (probably hidden!) and use:

=text(a2,"ddmmyy")

or

=text(a2,"mm:ss.0")

or

=text(a2,"00000")

(or whatever format I want)

and use that field in the mailmerge.

(Cheating doesn't bother me anymore <vbg>.)

Dorothy, Y wrote:

I am trying to make labels. I have put all the data into an excel spreadsheet. How do I take the data i have inputted and make it easy to cahnge into labels.

--

Dave Peterson