SendObject - Report PDF to Email

[WillJ]

Hi All,

Thanks inf advance for the help with this, I've spent a fair bit of time playing around with it but nothing seems to be working.

I am trying to send a report in PDF format using the SendObject command, this will execute when a check box is ticked.

The Error I get is;

'Compile error; Wrong number of arguments or invalid property argument'

I've been through a fair few times and can't see it : (! Help

The code is as follows;

Private Sub ProductionRequestsEmail_AfterUpdate()
If ProductionRequestsEmail = True Then
varTo = [ContactEmail]
varCC = "XXX@XXX.COM"
varSubject = [tbDocumentSubmissionID]
varBody = "Please find your attached report ... "

DoCmd.SendObject acSendReport, "rptPC", acFormatPDF, varTo, varCC, , varSubject, varBody, , , , True

End If
End Sub

 

[pr2-eugin]

Whats the last True for? Remove everything after varBody.

 

[WillJ]

You are a star : ).
Thanks, works a treat now!

 

[pr2-eugin]

Glad to help. Good Luck.