<div>
I created a work around using variables on the reports recordsource.
</div>


I created a work around using variables on the reports recordsource.

<div>
...Then post your workaround, and accept your own post...<br />
<br />
Accepting my post when it is not a solution will cause confusion when other members search here for the same issue<br />
<br />
;-)<br />
<br />
Jeff
</div>


...Then post your workaround, and accept your own post...

Accepting my post when it is not a solution will cause confusion when other members search here for the same issue

;-)

Jeff

<div>
<div class="content wysiwyg-content">
I have created a routing system for approvals of a budget request in Access. &nbsp;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. &nbsp;The first person in the routing liset sends an email back saying that it has been approved. &nbsp;The database reads the data from Outlook and then sends a an email to the second person in the routing list. &nbsp;The problem is when it is sent to the second person how do I generate the attachment. &nbsp;Can the SendObject command have a filter? &nbsp;What would the syntax be in the example below where<br />
CapEXID = 1. &nbsp;Thanks for your help!<br />
<br />
DoCmd.SendObject acSendReport, &quot;rptCapExRequests&quot;, acFormatPDF, varEmail, , , varSubject, varText, True
</div>
</div>


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

Send attatcment without opening report

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.