Solved

Docmd.sendobject from address

Posted on 2013-06-03
2
798 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
2 Comments
 
LVL 33

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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Auto Filter in Combo Box 7 32
data analyst 3 49
DBF to ... Converter 5 40
Two list boxes - best structure 3 31
I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

910 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now