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

[MichaelHunter]

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

 

[Doug Robbins - Word MVP]

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.

--
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

 

[MichaelHunter]

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.

 

[Doug Robbins - Word MVP]

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

--
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