Email Reports (1 Viewer)

[gnc]

I send my report to my email application. I loose my signature and all lines on the report. How can I email without having to re insert my signature and keep my lines from disappearing. I think I need to use a different file format but I don't know how.

 

[thocutt]

Here is my e-mail code. rtf or rich text formatting does not import picture files such as lines and signatures. Did you try HTML format? You may have to tweak the report a bit, but HTML format may send pictures. Good luck.


Private Sub MailChangeNotification_Click()
On Error GoTo Err_MailChangeNotification_Click

Dim stDocName As String
Dim stFormName As String
stDocName = "Change Notification"
stFormName = "E-Mail Change Notification"

'E-mails report, tells user, then closes dialog box.

DoCmd.SendObject acReport, stDocName, acFormatHTML, "dale.weldon@specialdevices.com; charles.yozgott@specialdevices.com; robin.neely@specialdevices.com", "tracy.hocutt@specialdevices.com; diane.kulisek@specialdevices.com", , "ASL Change Notification", "Here are the latest changes for the ASL.", False
MsgBox "The ASL Change Notification has been sent to all E-mail recipients."
DoCmd.Close acForm, stFormName


Exit_MailChangeNotification_Click:
Exit Sub

Err_MailChangeNotification_Click:
MsgBox Err.Description
Resume Exit_MailChangeNotification_Click

End Sub

 

[Atomic Shrimp]

I've got a report mailing demo that I put together for someone else, if you would like a copy, email me and I'll send it on the reply.

Mike