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

Tip: Looking for answers? Try searching our database.

Selecting the correct query

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
John Orban - 19 Feb 2004 13:09 GMT
I have an Access database. I run a macro that opens a Word document with
merge fields already in the Word document. In spite of the fact that I have
saved the data source in the Word file (I thought), Word asks which query,
in the database, to load. I can understand that since I have two separate
queries for two separate documents and I guess Word just needs to verify
which one goes with which document.

Is there any way to pass the query along with the Word document so the end
user doesn't have to make that choice? I just want them to click the
Switchboard button and have the Word document open to the correct query.

Thanks,

John Orban
The Country School
Easton, MD
Peter Jamieson - 24 Feb 2004 08:31 GMT
Which version of Word (and Access) is this?

If you open the Word document manually in Word (i.e. without going via
Access) does it ask for the data source?

You can always consider getting your Access macro to automate Word and open
the correct query using OpenDataSource.

--
Peter Jamieson - Word MVP
Word MVP web site http://word.mvps.org/

> I have an Access database. I run a macro that opens a Word document with
> merge fields already in the Word document. In spite of the fact that I have
[quoted text clipped - 12 lines]
> The Country School
> Easton, MD
 
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.