Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
tighe tighe is offline
external usenet poster
 
Posts: 11
Default excel merege Confirmation Dialog

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

 
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Confirmation then, bretsharon New Users 1 April 28th 07 03:42 PM
ASP.NET - Excel - Mail Merge in Word causes "Data Link Properties" dialog to appear. [email protected] Mailmerge 1 April 18th 06 02:38 PM
Dropdown menu in Word,Excel 2003 Open dialog box is taking long ti Ramakanth Microsoft Word Help 1 January 24th 06 12:46 PM
Activation- I don't know what the confirmation ID is? Diane Tables 1 August 10th 05 03:31 AM
how do you mail merege into business cards? VJ Mailmerge 1 July 13th 05 09:13 PM


All times are GMT +1. The time now is 09:30 PM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"