I am opening a report to send to users in an email using the Emaildatabaseobject in Access 2010. This works great, but I would like to add data to the subject line in the macro pulled from the report I am opening. The reportname is RMA_Admin, and the field on the report I want to pull from is RMA_Number. So I am trying to simply add the RMA number to the subject line and then add text to show it is closed so the final subject would read "RMA 577 is closed" for example. Is this possible to do in a Macro? I believe it can be done in VBA, but I am not sure about adding the pdf to the email. Any help is greatly appreciated.
Last edited:
