SendObject using acSendQuery (ACC2000)

  • Thread starter Thread starter Richard Torrie
  • Start date Start date
R

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
 
Back
Top