• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 372
  • Last Modified:

Send attatcment without opening report

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
  • 2
1 Solution
Jeffrey CoachmanMIS LiasonCommented:
<The problem is when it is sent to the second person how do I generate the attachment. >
See here to include the original attachment with the reply

<Can the SendObject command have a filter?>
It would seem that you would need to "Loop" trough all of these CapEXID values, and lock onto the email for each...
...but we would need to know a lot more about your design and how you are performing the "routing"...
Sasha42Author Commented:
I created a work around using variables on the reports recordsource.
Jeffrey CoachmanMIS LiasonCommented:
...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


Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now