Issue with sending emails from MS Access via outlook

Leonard Weber 1 Reputation point

I have successfully set up a process within Access that allows me to send emails through Outlook however, I have several Gmail accounts withing the Outlook programme - for different roles I have. I want to be able to specify which account the emails go out through so I can control which email address is used for replies. I have tried changing the order and the default settings of the Outlook accounts within Outlook to place the one I want to use at the top, and also to set it as the default, but from within Access only one account (not the one I want to use) is ever used (ie emails lodged in the outbox) no matter what settings I change in Outlook. Can anyone help.

Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
799 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. DBG 2,311 Reputation points

    Are you using Outlook Automation? If so, look up the SendUsingAccount property (if I remember correctly).

    Sent from phone...

    0 comments No comments