Can you email an access report as a .pdf file and if not - can you send the SnapShot viewer in the email?
Posted on 2008-09-30
This is a line of code I have from an old program:
DoCmd.SendObject acReport, rec!ReportName, acFormatRTF, rec!EmailAddress, "", "", "" & GlobalCurrentDate & " - " & rec!TypeDesc & " - " & rec!ReportType & "", "", False, """"""
It works great, but for the report I'm sending now - it drops a lot of the formatting I need. I'd like to send as a .pdf and we do have PDFCreator on the server. I'm using Access 2003. Again, if this is not possible, perhaps I can send the SnapShot Viewer in the email as well?