Hello

Thank you for the speedy reply. I will check with her to see if the data
source is still in the same location - as she has been given a new PC,
together with the new version of Office - perhaps she has moved it? If it is
in a different location and she moves it back to the original one, will it
work ok??

THanks again.

Louise

"Cindy M -WordMVP-" wrote:

Hi ?B?TG91aXNl?=,

A colleague of mine had Office 97 and has just been upgraded to Office XP.
However, she created numerous mail merges in 97 which she now needs to gain
access to but when she tries to open one of the documents containg the actual
merged letters that were created in 97 she gets this error message:-

Open this document will run the following SQL COmmand:
Select * From U:\my documents\etc....
Data from your database will be placed in the document, do you want to
continue? Yes No

Regardless of whether she chooses Yes or No, it opens the document but it
only has the first merged letter?

Putting aside any possible misunderstanding about merges, and records, and
such... The message in question has to do with a new security measure. It's
described, along with a way to get rid of it, in the following article. FWIW,
she should always answer "Yes" if she wants the merge document to open with the
data source still linked.

If she's getting the same with "Yes" as with "No", then the link to the data
source has been lost. This could be because the data source is no longer in the
same location as it was before?

"Opening This Will Run the Following SQL Command" Message When You Open a Word
Document - 825765
http://support.microsoft.com?kbid=825765

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail :-)