Hi guys,
I'm using MS Access 2016. I converted an email (with PDF report attachment) macro to VBA and very happy with the results except for one issue. When Outlook opens the message text always automatically populates on line 2 while the mouse cursor's focus is set to line 1 in the text body (1 line immediately above the auto-populated message text). Any assistance in getting the message text to auto-populate on line 1 would be greatly appreciated.
My vba is:
Kind regards,
Steve
I'm using MS Access 2016. I converted an email (with PDF report attachment) macro to VBA and very happy with the results except for one issue. When Outlook opens the message text always automatically populates on line 2 while the mouse cursor's focus is set to line 1 in the text body (1 line immediately above the auto-populated message text). Any assistance in getting the message text to auto-populate on line 1 would be greatly appreciated.
My vba is:
Code:
Private Sub CmdOpen _Click()
On Error Resume Next
DoCmd.SendObject acReport, "ReportName", "PDFFormat (*.pdf)", _
Me.TextLastname & " "& Me.TextFirstname, "", "", _
"My Subject is", _
"My message text is"
CmdOpenReportname_Click_Exit
End Sub
Kind regards,
Steve