merge mail question

[bb]

Word 2000. When I try to mail merge my Excel Worksheet 1 to mailing labels,
when I get to the merge fields it gives me F1, F2, etc. choices. I go
through F6 to include my zip codes. They don't ever show up. I've gone to
Format/Text and changed that, but it doesn't change a thing.
Then when I mail merge Worksheet 2 which is a random list from Worksheet one
with the same named cells, when I get to the merge fields, my choices are
First, Last, Address, etc. instead of F1, F2. Why is that different from
sheet to sheet? I go through the exact same process. Also, the zip codes
DO come through on Worksheet 2, BUT with a decimal and a zero on the end of
each one.
I am totally perplexed at this process and have sincerely tried to read and
help myself, but nothing has worked and I'm now frustrated and desperate.
Can someone please help me? If I've not been clear, please ask for more
details. Thanks.
bob

 

[Cindy Meister -WordMVP-]

Hi Bb,

By default, Word 2000 (This IS 2000 and not 2002, right?) uses a DDE
connection. But that can only connect to the first sheet.

If you're connecting to the second sheet, you must be specifying the
connection method. Which one are you choosing?

Do you not have field names in the top row of the Excel sheet, that it's
giving you F1, F2, etc.?

Word 2000. When I try to mail merge my Excel Worksheet 1 to mailing labels,
when I get to the merge fields it gives me F1, F2, etc. choices. I go
through F6 to include my zip codes. They don't ever show up. I've gone to
Format/Text and changed that, but it doesn't change a thing.
Then when I mail merge Worksheet 2 which is a random list from Worksheet one
with the same named cells, when I get to the merge fields, my choices are
First, Last, Address, etc. instead of F1, F2. Why is that different from
sheet to sheet? I go through the exact same process. Also, the zip codes
DO come through on Worksheet 2, BUT with a decimal and a zero on the end of
each one.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jan 24 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail

 

[bb]

Yes, it is Word 2000. I think I'm specifying ODBC. My names at top of
cells are First, Last, Address, City, State, Zip. I get F1, F2, et, for the
worksheet 1, but on worksheet 2 it gives First, Last, Address, etc. for
choices. I have zip codes in all of the G column on both worksheets. But
the ones on the first worksheet don't show up when I do a merge for mailing
lables.