Solved

Docmd.sendobject from address

Posted on 2013-06-03
2
826 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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Flowing down data to other tables 13 31
File.Search issue 8 29
VBA modules import 4 53
all contents of form cell highlighted access 2 7
In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Familiarize people with the process of utilizing SQL Server functions 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 Microsoft Ac…
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…

790 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