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

Docmd.sendobject from address

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
2 Solutions
NorieVBA ExpertCommented:

I don't think that's possible with DoCmd.SendObject.

You'll need to automate your email client, eg Outlook, export the report as PDF, attach it and set the sender etc.
Luke ChungPresidentCommented:
You won't be able to change the FROM address using the SendObject command.

Here's a paper that may help: DoCmd SendObject Command in Microsoft Access: Features and Limitations for Sending Emails
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

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

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