Access Mail Merge Document Query

[StellarCobol]

Hi All,

I have a word document that is used for a mail merge from Access, the document has mergefields on it, however the mail merge options to insert fields etc are greyed out.

Running this document from access it works perfectly, I can add merge fields from the query it is currently linked to and they populate.

My question is I want to change which query this document is using, where can ! do that?

I use the wizard to link to the query I start getting a prompt asking me if I want to run SQL, which doesn't currently happen.


Regards

Chris

[ranman256]

It sounds like the DB is disconnected from the doc. Run thru the mail merge wizard (in word) again and reconnect to the db, and get your new query.

[StellarCobol]

If I do that , then every time the document opens I get questioned as to whether I want to run SQL in the document, since the other documents don't do that, it won't be acceptable to the user.