Update data Source when the merge doc is opened?

[tcptang]

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.

 

[Doug Robbins]

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



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