Send attatcment without opening report
Posted on 2012-03-28
I have created a routing system for approvals of a budget request in Access. The user enters a request and clicks on button and a pdf attachment of the request is sent to the first person on the routing list. The first person in the routing liset sends an email back saying that it has been approved. The database reads the data from Outlook and then sends a an email to the second person in the routing list. The problem is when it is sent to the second person how do I generate the attachment. Can the SendObject command have a filter? What would the syntax be in the example below where
CapEXID = 1. Thanks for your help!
DoCmd.SendObject acSendReport, "rptCapExRequests", acFormatPDF, varEmail, , , varSubject, varText, True