"...merged field does not exist..." Driving me nuts!

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MichaelHunter - 10 Nov 2005 00:31 GMT

I upgraded to Office 2003 and now when I try to merge records from an Excel
DB into a main WORD doc, I get the message "Merged field is used in the main
doc but it does not exist in the data source."

This merge worked just fine hundreds of time in Office 2000.

I have tried using the MailMerge Helper button I placed in the bar but that
didn't improve things.

Any suggestions for fixing this problem would be greatly appreciated. I use
this merge a lot in my work.
Michael

Reply to this Message

Doug Robbins - Word MVP - 10 Nov 2005 05:13 GMT

All I can suggest is that you carefully check the field names in the
document against the column heading in Excel to make sure that they match
Exactly. Maybe best to get someone else to do it as it's very easy to
overlook something when you have done it a hundred times before.

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 upgraded to Office 2003 and now when I try to merge records from an Excel
> DB into a main WORD doc, I get the message "Merged field is used in the
[quoted text clipped - 11 lines]
> this merge a lot in my work.
> Michael

Reply to this Message

MichaelHunter - 10 Nov 2005 17:12 GMT

Thanks for your response Doug,
The field names have not been changed from when I used the DB with the
previous version of WORD, nor has the main document been altered in any way.

> All I can suggest is that you carefully check the field names in the
> document against the column heading in Excel to make sure that they match
[quoted text clipped - 16 lines]
> > this merge a lot in my work.
> > Michael

Reply to this Message

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

You might try turning on the "Confirm conversions at open" item under
Tools>Options>General in Word and try using different methods of connection
to the data source that will then become available. If that doesn't work,
if you want to send the data source and the main document to me, I will take
a look at it

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

> Thanks for your response Doug,
> The field names have not been changed from when I used the DB with the
[quoted text clipped - 22 lines]
>> > this merge a lot in my work.
>> > Michael

Reply to this Message