While I do not like the sound of your system - the mail merge main document
should be template, not an ordinary document, there is a possibility that
the issue you are experiencing is being caused by the Security Patch that
causes the following message to appear when you open a mailmerge main
document that has a data source attached to it
"Opening This Will Run the Following SQL Command ..." To see how to avoint
that, see the following Knowledge Base Article:
http://support.microsoft.com?kbid=825765

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 have a problem somewhat different from that posted by Laura on June 12,
> 2007. A friend of mine (systems engineer) created a complex database for
[quoted text clipped - 46 lines]
> not have to worry about formatting the merge fields. Would anyone have
> suggestions to resolve this?
George M - 26 Jun 2007 21:46 GMT
Doug,
Thanks, I will look at the KB article. We are looking at alternative methods
of connecting as well. The MDB's are all digitally signed so that may be a
problem as well. In any event will post back to the group how we resolve the
problem.

Signature
George M
> While I do not like the sound of your system - the mail merge main document
> should be template, not an ordinary document, there is a possibility that
[quoted text clipped - 57 lines]
> > not have to worry about formatting the merge fields. Would anyone have
> > suggestions to resolve this?
George M - 27 Jun 2007 14:46 GMT
Doug,
The KB article you mentioned I had already followed to eliminate that SQL
message and having read so many articles recently I had forgotten about it
when you posted your message. My friend seems to have found a simple solution
and that is always best! I will quote from his e-mail to me "I did try a
simple text export of the ExportCase query and did a mail/merge with Word and
it works fine. I think that is the best way to go because it stays
completely away from all security changes, inter-program operability issues,
etc.". Testing still has to be done but hopefully this is the final solution.

Signature
George M
> Doug,
>
[quoted text clipped - 64 lines]
> > > not have to worry about formatting the merge fields. Would anyone have
> > > suggestions to resolve this?