I have std mailmerge letter based on std access query (no criteria just the
fields) so i need to pass the criteria (sql 'Where' statement) dynamically
direct to the document in VB on it opening

Does mail merge doc support sql where statement? - Is this possible?

In the query design view grid add a column --
Criteria: [YourCriteriaPrompt]

Copy the criteria from the criteria row of the query so there will be no
errors and paste it after the colon in the field row. The criteria will
then be in the query output and available for use in Word Mailmerge.

"JethroUK©" wrote:

I have std mailmerge letter based on std access query (no criteria just the
fields) so i need to pass the criteria (sql 'Where' statement) dynamically
direct to the document in VB on it opening

Does mail merge doc support sql where statement? - Is this possible?

the merge document has to be based on an access form filter (std SQL Where
statement) - the query criteria is simple for Access:

[forms]![myform]![mycriteria]

yet apparently too complex for MS Word to use as a data source (doesn't even
show up as a possible data source unless i remove the criteria)

hence there's no copy/paste - hence the where statement (filter) has to be
done dynamically (programmatically)



"KARL DEWEY" wrote in message
...
In the query design view grid add a column --
Criteria: [YourCriteriaPrompt]

Copy the criteria from the criteria row of the query so there will be no
errors and paste it after the colon in the field row. The criteria will
then be in the query output and available for use in Word Mailmerge.

"JethroUK©" wrote:

I have std mailmerge letter based on std access query (no criteria just
the
fields) so i need to pass the criteria (sql 'Where' statement)
dynamically
direct to the document in VB on it opening

Does mail merge doc support sql where statement? - Is this possible?

From the Tools menu, selection Options and then on the General tab, check
the box for "Confirm conversions at open". Then when you attach the
datasource to the maindocument, you will be asked for the connection method
to be used. Try the DDE connection.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"JethroUK©" wrote in message
...
the merge document has to be based on an access form filter (std SQL Where
statement) - the query criteria is simple for Access:

[forms]![myform]![mycriteria]

yet apparently too complex for MS Word to use as a data source (doesn't
even
show up as a possible data source unless i remove the criteria)

hence there's no copy/paste - hence the where statement (filter) has to be
done dynamically (programmatically)



"KARL DEWEY" wrote in message
...
In the query design view grid add a column --
Criteria: [YourCriteriaPrompt]

Copy the criteria from the criteria row of the query so there will be no
errors and paste it after the colon in the field row. The criteria will
then be in the query output and available for use in Word Mailmerge.

"JethroUK©" wrote:

I have std mailmerge letter based on std access query (no criteria just
the
fields) so i need to pass the criteria (sql 'Where' statement)
dynamically
direct to the document in VB on it opening

Does mail merge doc support sql where statement? - Is this possible?