Hello,
I am trying to change the name of my report before sending it as attachment by email.
DoCmd.SendObject acReport, "Myreport", "PDFFormat(*.pdf)", "", "", "", "For your Info: " & Forms![frmMain]!LastName & " - " & Forms![frmMain]!FirstName, "Your action is required. Thank you", False, ""
As indicated in the subject line of the email, I would also like to name the report with values in the two textboxes, LastName and FirstName.
Thank you for your help.
I am trying to change the name of my report before sending it as attachment by email.
DoCmd.SendObject acReport, "Myreport", "PDFFormat(*.pdf)", "", "", "", "For your Info: " & Forms![frmMain]!LastName & " - " & Forms![frmMain]!FirstName, "Your action is required. Thank you", False, ""
As indicated in the subject line of the email, I would also like to name the report with values in the two textboxes, LastName and FirstName.
Thank you for your help.