I have now found out more details to the original scenario. The
default account is an Exchange Mailbox and the other account is a non-
Exchange mailbox hosted elsewhere on the WAN. Both can be configured
in Outlook.

Would the above suggestion when sending on behalf route the message
via that mail connection or go via the default?

On 22 Nov, 23:50, "Sue Mosher [MVP-Outlook]"
wrote:
AFAIK, each user would need to do that manually. Maybe an Access forum would have other ideas.

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54

"Robin9876" wrote in ...
How would you add the Outlook reference see it works on pc's with
Outlook 2003 or 2007 installed?

On 22 Nov, 16:23, "Sue Mosher [MVP-Outlook]"
wrote:
Set the SentOnBehalfOfName property of the outgoing message to the mailbox alias.

"Robin9876" wrote in ...
In VBA code (from Access) what is required to create and send mail via
Outlook from a named Exchange Mailbox, where there are more than 1
Exchange Mailboxes configured in Outlook?