Ray
You can send an email from Access using DoCmd.SendObject. I'd build a form that has the To; CC; Subject and body fields with a button to send. That way, you can capture all those fields into a table the same as you would for any form.
No need to start in Outlook. And as Jim said you can link to the contacts table so the user can select the address(s) he wants.
Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
http://mvp.microsoft.com/en-us/mvp/Bill%20Mosca-35852
My nothing-to-do-with-Access blog
http://wrmosca.wordpress.com
---In MS_Access_Professionals@yahoogroups.com, <rayfrew@gmail.com> wrote :
Hi everyone,
I'm not sure if this is possible but...........
What I'd like to do is send an email from Outlook (to a customer) and blind copy the contents along with the recipient's email address into a table in Access. I expect that the table would be simply, PKey, Emailaddress, message. I want to create a history of emails sent to customers - nothing fancy, just the text.
I've successfully created emails that start in Access and use Outlook to send them but can it be done the other way round?
I'm excited about the challenge but as I don't know where to start, I'd appreciate your thoughts and pointers on this. I'm using Access 2010 and Access 2013.
Many thanks
Ray
__._,_.___
Posted by: wrmosca@comcast.net
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (3) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar