2002 - 2003

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Michael Koerner - 20 Oct 2003 18:44 GMT

I have a number of mail merges set up, using Excel as the data source. the merges work just fine in Word & Excel ver 97/2002

When I moved my files into 2003, I'm continually receive the following message when I open the merge document.

"Opening this document will run the following SQL command:
SELECT *From 'Nominal Roll$'
Data from your database will be placed in the document. Do you want to continue?..."

How do I turn this off so as not have to indicate yes every time I open the document?

Signature

Regards
Michael Koerner

Reply to this Message

Karl - 23 Oct 2003 12:46 GMT

I have the same problem with a textfile datasource. In
Word XP (and previous versions) the document opens with
the mergefields visible, in word 2003 it wants to
run "select * from <mytextfile.txt". Obviously that does
not work.
I'd love to find out how to turn this SQL behavier off.

Regards
Karl Christian Grønhaug

>-----Original Message-----
>I have a number of mail merges set up, using Excel as the data source. the merges work just fine in Word & Excel ver

97/2002

>When I moved my files into 2003, I'm continually receive the following message when I open the merge document.
>
[quoted text clipped - 3 lines]
>
>How do I turn this off so as not have to indicate yes every time I open the document?

Reply to this Message

Michael Koerner - 23 Oct 2003 13:53 GMT

I did by luck, find a MSKB article on this. the article number is 825765 entitled "Opening this will run the Following SQL Command" Message when you open a Word Document.

Their answer is to edit the registry and insert a VBA macro into the document. saying that this message helps protect you from unintentionally sending data to a malicious user.

Hope this is of some use to you, as I know diddly about editing the register and less about where to put VBA stuff.

Signature

Regards
Michael Koerner

>-----Original Message-----
>I have a number of mail merges set up, using Excel as the

data source. the merges work just fine in Word & Excel ver
97/2002

>When I moved my files into 2003, I'm continually receive

the following message when I open the merge document.

>"Opening this document will run the following SQL command:
> SELECT *From 'Nominal Roll$'
>Data from your database will be placed in the document.

Do you want to continue?..."

>How do I turn this off so as not have to indicate yes

every time I open the document?

Reply to this Message