Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Sep 2001
    Location
    Stuck at work..., Missouri, USA
    Posts
    248
    Thanks
    0
    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>
    morgan.erickson@sprint.com
    <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.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •