Ravi Kumar
Registered User.
- Local time
- Today, 21:19
- Joined
- Aug 22, 2019
- Messages
- 162
Can anyone please tell me what did I missed in the below, it is coming as syntax error.
Code:
Private Sub cmdmailppm_Click()
DoCmd.SendObject acSendReport, "PPM table", acFormatPDF, "Sanjay.Joseph@plansee.com" & ";" & "Ramandeep.Singh@plansee.com", "Prabha.Tirupatiananthachar@plansee.com", , "PPM Trend", "Dear all" & vbCrLf & "Please refer the attached file for the ppm trend" & vbCrLf & "Thank you" & vbCrLf & "Abishek"
On Error GoTo errmsg
errmsg: MsgBox("Last action was Cancelled", vbOKOnly, "mail not sent")
End Sub