Maybe the printer is going to use merge to print the lables. I suggest
the "client" request the excel template from the printer so you may
format the addresses properly. Without that who knows what the printer
wants.

Donna wrote:

My client needs to have the labels in spreadsheet format for a printer to
print postcards for him. why the printer doesn't know how to convert the
data I don't know, but I need the labels in .xls format.

"Dave Peterson" wrote:


You may find using MSWord and its builtin mailmerge easier. It supports lots of
different forms (Avery standard forms???) that might make it easier.

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 just in case you have text that needs to be formatted (percentages, for
example):

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/as...164951033.aspx

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

http://sbarnhill.mvps.org/WordFAQs/C...ngWord2002.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,"00000")
(or whatever format I want)
and use that field in the mailmerge.

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


Donna wrote:

I have a document in word setup as Avery 5160 label format. How to I import
that into Excel using Excel 2000 or older version. I have XP so cannot match
instructions to the person I'm trying to explain this to.

Any immediate help greatly appreciated, he's breathing down my back as we
speak.

--

Dave Peterson