Hello and thank you again for all assistance provided in the past! I am slowly getting my database to function in a way that should make my end users happy AND I'm enjoying the process of learning to code (and debug).
The issue stumping me is this latest error message, which pops up when I click the "Send Email" command button in my Form. On click, the Event Procedure is:
Code:
Private Sub Command103_Click()
DoCmd.SendObject acSendReport, rptNewActivityReport, acFormatPDF,
Me.cboSupervisor.Value, "(Employee name to be cc'd)", Me.cboEmployee.Value,
"NEW EHS ACTIVITY" & Me!ID.Value & "HAS BEEN CREATED" & Date,
"THIS IS A TEST EMAIL. A new EHS Activity has been initiated. Please review the Activity and assign an Owner. Click the Notify Owner button when complete. Thank you!",
True
The caption for the report is indeed rptNewActivityReport.
Any suggestions regarding why this is failing?
Similar code for a command button to send email to an issue owner (assigned later in the process) works just fine, and its code is:
Code:
DoCmd.SendObject acSendForm, frmActivityDescription, acFormatPDF,
Me.cboOwner.Value, "(Employee name to be cc'ed)", ,
"EHS Activity " & Me!ID.Value & " has been assigned to you on " & Date,
"Congratulations! An EHS Activity has been assigned to you. Please assign Corrective Actions and a Target Date for this activity.",
True