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 / July 2004

Tip: Looking for answers? Try searching our database.

Mail Merge Help

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Ilan - 22 Jul 2004 15:00 GMT
hello,
    I have an open query which asks the user to input
month and year (in format ##/####) for when individuals
join a particular professional organization.
    Basically in my criteria for the query i use the [ ]
operators to prompt the user for to imput a month and
year.  
    Now, i use a RunApp Macro to send the results of the
query to Word for a mail merge.  However, when i am
setting up my main document, i cannot select my query
because it is not listed.  
   I believe it is not listed because it is an open
query.  I am using Access and Word versions 2002 and i
found that it worked successfully in office 2000.  

Does anyone have any solutions on how to get this to work?

Much appreciated,
Ilan
Rsandhofer - 22 Jul 2004 16:30 GMT
Ilan,
Look at in Microsofte knowledge base at article
833064 "word was unable to open the data source error
message in word mail merge when you use an access
parameter query in access 2002".  When I try the method
1, I see my query.  My query has multiple parameters and
I had some problems.  So, I am trying method 2 - saving
to a file.  I Still have other issues to work throught.  
I hope the article might help you some with your problem.
Good luck.
R.Sandhofer
>-----Original Message-----
>hello,
[quoted text clipped - 17 lines]
>Ilan
>.
 
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.