[tighe]

All,

Whenever I run an automated merge with excel as the data source a dialog box
appears and the user has to confirm the data source. How can I avoid this?

Set objWord =
appWord.Documents.Open("G:\cmcdb\20080922_CMCDB2\D ocuments\Ext_IA_prop_cvr_and_quote.dotm")

' Set the mail merge data source as the database.
objWord.MailMerge.OpenDataSource "G:\cmcdb\Employees\" &
[Forms]![001_Start]![consultant_ini] & "\Prospect_IA_Proposal.xlsx",
LinkToSource = True, ConfirmConversions = False

' Execute the mail merge.
objWord.MailMerge.Execute

If I merge in the same manner from a rtf file no further user input is
required.
This is a cross office product issue, I run this code from access, but
thought this the best place to post. I know you can cross post issues but
not exactly sure what the "use full USENET designation" would be.

Office 2007/XP