SendObject Function

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

Guest

Hi

Hope somebody can help I am using the below code in Access 97 (Not my Fault
Work wont Upgrade) to export the Query Export Data into the Message area of
an E-Mail in HTML Format. At the minute this is coming through as an
attachment to Plain Text.

DoCmd.SendObject acSendQuery, "Export Data", acFormatHTML, "Tony Burns;", ,
, strSubject, strMsg, False

Any Help would be appreciated
 
Tony,
While you can control some aspects of the SendObject function, (To, From,
Subject, etc..) the basic "object" you're sending (a report, form,
query,...etc) are all sent as attachments to the email.
To the best of my knowledge, SendObject can't insert them into the "body"
of the email.
hth
Al Camp
 
Back
Top