MS Word doc open with Autoit does not allow MS Mailings to connect to data in Excel file

[tv69]

Hello everyone,

I'm new to the world of Autoit and I'm finding code examples for what I'm trying to do.

I'm using the following code I found online to open a word document.

#include <word.au3>
$oWord = _Word_Create()
Global $sDoc = "....path...docx"
$oDoc = _Word_DocOpen($oWord, $sDoc)
ConsoleWrite(@error & @LF)

It works just fine to open the document however the document uses MS Word Mailings to fetch information from an Excel file.  Using this script does not bring up the pop up when the MS Word file is opened which tries to connect to the data in the Excel file by running an SQL command which you are asked yes or no to run.

I tried to attach a jpg of the popup but had a hard time finding how.

Can someone please be so kind as to give me a bit of help?

Thank you,

TV

[water]

What's the value of property DisplayAlerts aftert the document has been opened?

MsgBox(0, "", $oWord.DisplayAlerts)

[tv69]

Hi water,

I added your line of code and it returned "0" in the msgbox.  I suppose DisplayAlerts needs to be turned on?  How would that be done?

Thanks for your help.

TV

[water]

Unfortunately I have never used MS Word Mailing.

Seems we need to tell Word to not supress messages. I will investigate when I return to my office (end of the week).