Controling a dialog box after I've selected the datasource

G

Guest

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

PamBjerke

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
Click to expand...
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
Click to expand...
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
Click to expand...
excel therefore erasing any user input? I would like to
select the entire spreadsheet.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How disable an Excel dialog box? 4
Automating key strokes to a dialog box 2
how do I clear a dialog box option 1
Format Cells Dialog Box won't display! 1
Help with Custom Dialog Box 3
Suppress Error Dialog: "Data may exist in the sheet(s) selected for deleting...." 2
Mail merge macro: select recipients from Excel during merge 0
Common Dialog Box 2

Top