mailmerge query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Strange problem.
I have a set of databases combined in a query in order to make some
documents in Word: confirmation for visit, document to the chef de cuisine
with some details....
The query works perfectly.
When I try to "link" to the word document, my (working) query isn't in the
list of available queries.
Maybe a reason why it happens. In my query I use a "selection" i.e. the
active record through a criteria IN the query =>[Forms].[Visites].[IdVisit],
the last being my key-item for one of the tables.
Anyone an idea if the "criterium" could be the reason ??
I'm thinking of an other solution: could be eventualy by introducing the
"criterium" in my macro set.
Thanks for any help or idea
 
I export the data from Access to a different source, like Excel, then base
the merge on that. Word never seems to understand that the queries exist.

For future Word help, you may want to try the Word newsgroups, too.
 
Hi Steve,
Thanks for your suggestion. I found the right answer in the word-group. The
answer was posted in the item of 4/25/2005 from Sarah B.
In fact one has to change the connection to word in a DDE or OBDC link
through word|options|general tab| and check the "confirm conversion on open"
box.
This gives you different possibilities and let you make a merge of one
selected record in your dbase.

Thanks
--
cram


[MVP] S.Clark said:
I export the data from Access to a different source, like Excel, then base
the merge on that. Word never seems to understand that the queries exist.

For future Word help, you may want to try the Word newsgroups, too.

--
Steve Clark, Access MVP
http://www.fmsinc.com/consulting
*FREE* Access Tips: http://www.fmsinc.com/free/tips.html

cram said:
Strange problem.
I have a set of databases combined in a query in order to make some
documents in Word: confirmation for visit, document to the chef de cuisine
with some details....
The query works perfectly.
When I try to "link" to the word document, my (working) query isn't in the
list of available queries.
Maybe a reason why it happens. In my query I use a "selection" i.e. the
active record through a criteria IN the query
=>[Forms].[Visites].[IdVisit],
the last being my key-item for one of the tables.
Anyone an idea if the "criterium" could be the reason ??
I'm thinking of an other solution: could be eventualy by introducing the
"criterium" in my macro set.
Thanks for any help or idea
Click to expand...
Click to expand...
 
Back
Top