Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / September 2004

Tip: Looking for answers? Try searching our database.

Merge using MSQuery as data source doesn't allow use of parameters

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Paul Patten - 07 Sep 2004 13:58 GMT
I created a MSQuery that accesses an Oracle database and I used a parameter
in one of the data field which works fine when running the MSQuery as a
stand alone. But, when I use this query as the data source for the mail
merge in a Word document I get the error "Parameter not allowed for this
query".  My question is how do you get a parameter box to open for the entry
of retrieval criteria to limit the merge data?  I'm try to do something that
simplifies the process for the end user so they don't have to modify the
select criteria in the actual query.

Thanks for any help.
Cindy M  -WordMVP- - 13 Sep 2004 20:01 GMT
Hi Paul,

As far as I know, you can't do it this way. Maybe a little VB app, to allow
the parameter input, then link to the data source?

Or a VBA form interface within the mail merge template.

> I created a MSQuery that accesses an Oracle database and I used a parameter
> in one of the data field which works fine when running the MSQuery as a
[quoted text clipped - 4 lines]
> simplifies the process for the end user so they don't have to modify the
> select criteria in the actual query.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail :-)
 
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.