Mail Merge: Excel (XP) fields scrambled during merge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Adprof - 10 Nov 2005 15:00 GMT

I have been trying to merge a newly created Excel XP database with a newly
created letter--but, I am witnessing a phenomenon I have never encountered
with Mail Merge. The Excel fields are coming in scrambled. That is, I set up
the fields in the following order: company, street, town, state, zip. But it
comes into the letter as: state, zip, company, street, town. And, no matter
what I do, I cannot correct it. This is the first time I have ever seen this.
Has anyone else ever seen it, and if so, how can it be corrected?

Reply to this Message

Doug Robbins - Word MVP - 10 Nov 2005 18:43 GMT

If you are using the Address Block, don't.

Just insert the individual mergefields in the configuration that you want
them.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>I have been trying to merge a newly created Excel XP database with a newly
> created letter--but, I am witnessing a phenomenon I have never encountered
[quoted text clipped - 7 lines]
> this.
> Has anyone else ever seen it, and if so, how can it be corrected?

Reply to this Message