sanders720
Programmer
I have a report that is being called via e-mail. When I was testing, I used Preview to assure that the form looked correct. In the process, I used the Activate event to populate three areas of the report, as indicated in the code below. The problem is, this judt doesn't take in the snapshot format with the e-mail.
Private Sub Report_Activate()
LoginName
Me.txtRelBy.Value = EmployeeINIT
Me.txtRelDate.Value = Date
Me.txtNeedBy.Value = Forms!frmPurchasedPartsListPRE.txtNeedBy.Value
' Close Out Form
Forms!frmPurchasedPartsListPRE.Close
End Sub
The line of code for the email looks as follows...
' Send E-Mail
DoCmd.SendObject acSendReport, "rptPurchased Parts List EE", "Snapshot Format", "abc@def.com", "xyz@def.com", , "Metro Requisition: " & RN + 1 & " Ready for Processing. Preferred Delivery by " & txtNeedBy & ".", "The attached file represents the data that is in the Purchased Requisition Database. Please save the file for reference. Feel free to contact me if you have any questions about it."
Thanks in advance for any help you can provide
Private Sub Report_Activate()
LoginName
Me.txtRelBy.Value = EmployeeINIT
Me.txtRelDate.Value = Date
Me.txtNeedBy.Value = Forms!frmPurchasedPartsListPRE.txtNeedBy.Value
' Close Out Form
Forms!frmPurchasedPartsListPRE.Close
End Sub
The line of code for the email looks as follows...
' Send E-Mail
DoCmd.SendObject acSendReport, "rptPurchased Parts List EE", "Snapshot Format", "abc@def.com", "xyz@def.com", , "Metro Requisition: " & RN + 1 & " Ready for Processing. Preferred Delivery by " & txtNeedBy & ".", "The attached file represents the data that is in the Purchased Requisition Database. Please save the file for reference. Feel free to contact me if you have any questions about it."
Thanks in advance for any help you can provide
