SendObject using acSendQuery (ACC2000)

[Richard Torrie]

I am trying to send an email with a predefined query attached using the
following code.

DoCmd.SendObject acSendQuery, "Query1", acFormatHTML, MyQuery02![E-mail], ,
, "Subject Description", , 0

I can get this to work but the problem is that the query looks for certain
details from the currently opened form that then sends the email.

For some reason the query is empty, this work perfectly well using Access
97.

Richard Torrie

 

[Richard Torrie]

False alarm, my query was looking for the wrong parameters.