Emailing report

  • Thread starter Thread starter Tony Williams
  • Start date Start date
T

Tony Williams

I have a tick box on a form that should email a report. This is my code
DoCmd.SendObject , "rptOnlineUpload", acformtxt, , , , "OnLineUpload",
"Please upload this document to Online", True

However although the email opens in Outlook with the message there is no
report. According to the help I thought the report should appear benaeth the
message. What am I doing wrong?
TIA
Tony Williams
 
Tony,

Your code leaves out the ObjectType argument (the default for which is
acSendNoObject). Try this ...

DoCmd.SendObject acSendReport, "rptOnlineUpload", acformtxt, , , ,
"OnLineUpload",
"Please upload this document to Online", True

hth,
 
Thanks Cheryl works just fine
Tony
Cheryl Fischer said:
Tony,

Your code leaves out the ObjectType argument (the default for which is
acSendNoObject). Try this ...

DoCmd.SendObject acSendReport, "rptOnlineUpload", acformtxt, , , ,
"OnLineUpload",
"Please upload this document to Online", True

hth,
Click to expand...
 
Back
Top