Merge fields switched

[Melissa]

Hello,
I am creating a mail merge (labels) with Excel 2000. It
works fine except for that it switches the order in which
I place my fields and it discludes some information.

For instance, I'll Put NAME, PHONE, FAX, CONTACT 1,
CONTACT 2, ADDRESS. What happens is that ADDRESS ends up
on top of the label (buisness card) and the NAME ends up
on the bottom in the final document after I've done the
merge. In the main document, it shows the fields in the
correct order, but when I click the "Show merged data"
button, it is switched again.

As for discluding information, some of my fax numbers are
not showing up when I know that they are present in the
spreadsheet.

To eliminate the possiblity of the spreadsheet being
corrupt, I did a copy and paste special values in to a new
spreadsheet. I also set up a defined name for my table.
None of this solved the problem. Any help would be
greatly appreciated.

Thanks!

 

[Melissa]

I've figured it out...the fields have to be in the same
order on the spreadsheet as you want them to appear in the
merge.

 

[Cindy M -WordMVP-]

Hi Melissa,

Thanks for posting this... The described behavior is
decidedly weird - I can't recall having ever seen it happen,
or seen a report about it happening. I'm glad you found a
workaround!

I've figured it out...the fields have to be in the same
order on the spreadsheet as you want them to appear in the
merge.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep
30 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