Solved

Docmd.sendobject from address

Posted on 2013-06-03
2
858 Views
Last Modified: 2013-06-18
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
0
Comment
Question by:iainmacleod
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 34

Assisted Solution

by:Norie
Norie earned 250 total points
ID: 39216733
Iain

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.
0
 
LVL 10

Accepted Solution

by:
Luke Chung earned 250 total points
ID: 39218490
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
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question