[Doug Robbins - Word MVP]

Send me a copy of the spreadsheet (with some dummy data if you wish) and the
mail merge main document and I will take a look at it.

--
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, originally posted via msnews.microsoft.com

"Nick C" wrote in message
...


"Doug Robbins - Word MVP" wrote:

It sounds like you might have used field matching to match the fields in
your data source to the "standard" field names. That is not necessary
and
you can just insert your actual field names in the configuration that you
want them.

In this case however, you will probably need to edit the main document by
deleting the existing mergefields (or at least those that are not
returning
the correct data) and then reinsert the required fields in the places
that
you want them.

Deleting the merge fields and re-inserting doesn't help. It has to do
with
something causing the data to shift from the columns when reading through
DDE. In fact, some data won't pull from Excel via DDE; it doesn't appear
under any field.

I tried creating a new Excel sheet from scratch and putting in all the
columns but it still pulls incorrectly.