 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / April 2008Mail Merge Parameter Double Prompt
I am using Office 2003 I have a Parameter query in Access that prompts for the ID. I have a Mail Merge Template that runs the parameter query with only 1 problem. It double prompts for the ID ~ any help? In Word, select Options from the Tools menu and then go to the General tab and check the box against the "Confirm conversions at open" item. Then when you attach the data source to the mail merge main document, select the DDE option and try it then. I think that one may overcome the problem, but if not, try the other options as well.  SignatureHope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP >I am using Office 2003 > > I have a Parameter query in Access that prompts for the ID. I have a Mail > Merge Template that runs the parameter query with only 1 problem. > > It double prompts for the ID ~ any help? I've already done those things...any other ideas? Is it because it is in a template? > In Word, select Options from the Tools menu and then go to the General tab > and check the box against the "Confirm conversions at open" item. Then when [quoted text clipped - 8 lines] > > > > It double prompts for the ID ~ any help? Is there any code (macros) in the template? SignatureHope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP > I've already done those things...any other ideas? > [quoted text clipped - 17 lines] >> > >> > It double prompts for the ID ~ any help? No - no code. When I open it as a template - it just prompts once; but when I open as a new doc, it prompts twice. > Is there any code (macros) in the template? > [quoted text clipped - 19 lines] > >> > > >> > It double prompts for the ID ~ any help? Becky, I have the exact same issue. Did you ever get any insight?? > No - no code. When I open it as a template - it just prompts once; but when > I open as a new doc, it prompts twice. [quoted text clipped - 22 lines] > > >> > > > >> > It double prompts for the ID ~ any help? Initiate the Merge from Access. SignatureHope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP > Becky, > I have the exact same issue. Did you ever get any insight?? [quoted text clipped - 31 lines] >> > >> > >> > >> > It double prompts for the ID ~ any help? Hi Doug, unfortunately I don't think I have that option. I have a main/procedure document that "links" to a series of Word templates via command buttons which use the same parameter query as a data source. The user progresses thru the procedure and generates/uses the template based documents as necessary. I'm not sure I could convert the main/procedure document to access...if that's what you're suggesting. Is there ANY way to suppress one of the parameter prompts?? TIA cal > Initiate the Merge from Access. > [quoted text clipped - 33 lines] > >> > >> > > >> > >> > It double prompts for the ID ~ any help? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.