<div>
<div class="content wysiwyg-content">
Hello,<br />
I am using docmd.sendobject to email a report out and all works well. I would like to be able to have the email sent from a specific email address or a reply to to specify an address. (Invoices emailed by all members of staff but I want any replies to go back to accounts@xxxx.com)<br />
This is what I use:<br />
DoCmd.SendObject acSendReport, &quot;alterviewinvoice&quot;, acFormatPDF, emailadd, , , &quot;Your Invoice Number &quot;&nbsp;&amp; Me.invno &amp;&nbsp;&quot; is attached&quot;, &quot;Please find our invoice attached&quot;, True<br />
<br />
Any help greatly appreciated<br />
Iain
</div>
</div>


Hello,
I am using docmd.sendobject to email a report out and all works well. I would like to be able to have the email sent from a specific email address or a reply to to specify an address. (Invoices emailed by all members of staff but I want any replies to go back to accounts@xxxx.com)
This is what I use:
DoCmd.SendObject acSendReport, "alterviewinvoice", acFormatPDF, emailadd, , , "Your Invoice Number " & Me.invno & " is attached", "Please find our invoice attached", True

Any help greatly appreciated
Iain

Docmd.sendobject from address

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.