Controling a dialog box after I've selected the datasource
 

Hi
(Word 97)
(Excel 97)

I'm trying to fully automate a mailmerge from excel but I'm stuck automating a dialog box that appears after I've selected the datasource. (the datasource is in excel).

The dialog box appears after I've selected the datasource. The title is "Microsoft Excel" and I have two options to merge, Entire Spreadsheet and _FilterDatabase.

Does anybody know how I can control this dialog box from excel therefore erasing any user input? I would like to select the entire spreadsheet.

Any clues would be appreciated.

Controling a dialog box after I've selected the datasource
 

Try
oWord.ActiveDocument.MailMerge.OpenDataSource
Name:=myexcel.xls, Connection:="Entire Spreadsheet"


-----Original Message-----
Hi
(Word 97)
(Excel 97)

I'm trying to fully automate a mailmerge from excel but
I'm stuck automating a dialog box that appears after I've
selected the datasource. (the datasource is in excel).

The dialog box appears after I've selected the
datasource. The title is "Microsoft Excel" and I have two
options to merge, Entire Spreadsheet and _FilterDatabase.

Does anybody know how I can control this dialog box from
excel therefore erasing any user input? I would like to
select the entire spreadsheet.

Any clues would be appreciated.
.