Unwanted dialog in automated mailmerge

[Marco van Zelst]

Hi all,

I am using Office 2002/XP to automate a Word mailmerge
using an Excel file as datasource.

My problem is that Word displays a dialog in the
mailmerge process in which the user has to specify the
sheet in the Excel workbook. I don't want that dialog to
popup, the Excel datasource file only has 1 sheet so
there is nothing to choose anyway.

Where can I programmatically specify the sheet to use?
The OpenDataSource method doesn't seem to have an option
for this.
Is there a way to prevent this dialog to popup and still
use the Excel file?

TIA,

Marco

 

[Cindy Meister -WordMVP-]

Hi Marco,

Record linking to the Excel spreadsheet in a macro.

I am using Office 2002/XP to automate a Word mailmerge
using an Excel file as datasource.

My problem is that Word displays a dialog in the
mailmerge process in which the user has to specify the
sheet in the Excel workbook. I don't want that dialog to
popup, the Excel datasource file only has 1 sheet so
there is nothing to choose anyway.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update
Jan 24 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