Mail Merge from query with Like criteria (1 Viewer)

Dick7Access

Dick S
Local time
Today, 04:48
Joined
Jun 9, 2009
Messages
4,197
Once again I have a great need to mail merge word with a query that has a Like criteria, but while a straight query will show up in the list the queries with like do not show up. :banghead: Why :banghead::banghead::banghead:
 

ypma

Registered User.
Local time
Today, 08:48
Joined
Apr 13, 2012
Messages
643
Don't pretend to know the answer to your question, but I had a similar problem and solved it by. 1 .created a local table with the query, 2, then changed the query to append query for the subject record to the new local table, 3,You will need to delete all records prior to appending the selected record.. The new table then becomes the data source for your word document.
I suppose you could also make another query from your original query and use the new query as your data source. Not tested
If I have stated the obvious apologies
 

Users who are viewing this thread

Top Bottom