Word Merge Issue? Field not present in data source, but it is!

[pianoprodigy]

We use an Access database to merge data into a document. I edited the existing query to add 3 new fields, but when I run the merge, Word says "The merge field is contained in the main document but not in the data source." It then gives me the option to substitute if for another field.

What's going on here?

This comes up in place of the fields when I cancel the merge...
Error! MergeField was not found in header record of data source.

 

[Travis]

What are the field names that you added to the query.

What are the names you used when you added the fields to the word document?


Did you use spaces in the field names?

 

[pianoprodigy]

No, there aren't spaces in the name. There is capitalization. MinorFirstName

 

[Travis]

Then to test remove the offending field from the Word Document. Run the merge (to verify that you don't get any messages). Once you have a clean run try adding the field back in.

 

[Pat Hartman]

I don't do a lot of work with Word so I'm guessing but perhaps you need to force Word to "refresh" its view of the query so that it will recognize the new field. If you haven't saved and reopened the doc since you changed the query, do so. If that doesn't fix the problem, try deleting the reference to the query and then readding it. That works for forms and reports.