Update data Source when the merge doc is opened?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

tcptang - 08 Nov 2004 05:10 GMT

Hi,

I haved created a mail merge document and the data file is in Access. I'm
using Office XP under Windows XP SP2. I got the following message whenever I
open the document in office but not at home.

> Opening this document will run the following SQL command:
> Select * from tblConveyance
> Data from your database will be placed in the document. Do you want to continue?

Please advise how to get rid of this message.

Also, how to merge a specific record from the table, tblConveyance. Can I
set something at the SQL in mailmerge. I've tried to set the
".DataSource.QueryString" but it doesn't work.

Thanks million.

Reply to this Message

Doug Robbins - 10 Nov 2004 04:21 GMT

See the following Knowledge Base article:

"Opening This Will Run the Following SQL Command" Message When You Open a
Word Document - 825765 at:

http://support.microsoft.com?kbid=825765

Signature

Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP

> Hi,
>
[quoted text clipped - 15 lines]
>
> Thanks million.

Reply to this Message

Rate this thread: