Results 1 to 2 of 2
2009-09-28, 15:37 #1
- Join Date
- Sep 2001
- Stuck at work..., Missouri, USA
- Thanked 0 Times in 0 Posts
I have a database that crunches numbers and needs to send e-mails to about 200 people.
My boss's boss decided they should come from an e-mail account I have permission to use, but I can only access it in Outlook by Tools, E-mail Accounts then Open These Additional Mailboxes. Since my e-mail account is the default, it Access wants to send from my account, not that additional one...
How do I get around that?
Thanks!<font face="Comic Sans MS">Morgan Erickson</font face=comic>
<img src=/S/flags/USA.gif border=0 alt=USA width=30 height=18>-From <img src=/S/flags/Colorado.gif border=0 alt=Colorado width=30 height=18> but living in <img src=/S/flags/Missouri.gif border=0 alt=Missouri width=30 height=18>...and working in Kansas.
2009-09-28, 15:46 #2
- Join Date
- Mar 2002
- Thanked 28 Times in 28 Posts
You cannot specify the sender using DoCmd.SendObject. You'd have to logon to Windows as the user you want to act as sender.
Alternatively, you could use Automation to control Outlook from Access but then you'd only to be able to specify the "Sent on behalf of" name - for security reasons, Outlook VBA doesn't allow you to change the actual sender.