Controling a dialog box after I've selected the datasource

[JimPNicholls]

H
(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.

 

[Cindy M -WordMVP-]

Hi =?Utf-8?B?SmltUE5pY2hvbGxz?=,

Have you tried recording making the link to the data source in a macro? Please show us the code you're using.

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

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003)
http://www.mvps.org/word

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