View Single Post
  #6  
Old November 23rd 07, 03:18 PM posted to microsoft.public.outlook.program_vba
Sue Mosher [MVP-Outlook]
external usenet poster
 
Posts: 11,651
Default VBA to Send message from a named Mailbox

No, for that scenario, you'd need to set the actual send account. Outlook 2007 adds a MailItem.SendUsingAccount property. For earlier versions, Outlook provides no direct way to change the account for an outgoing message. These are known workarounds using native Outlook functionality:

1) If the user has Outlook 2002/3 and is not using WordMail as the editor, you set the sending account using CommandBars techniques. See http://www.outlookcode.com/codedetail.aspx?id=889 for sample code.

2) If you're mainly concerned about replies to your message going to the correct place, add the desired reply address to the MailItem.ReplyRecipients collection.

The third-party Redemption ( http://www.dimastr.com/redemption/ ) library adds another solutions:

3) Set the RDOMail.Account property, as described at http://www.dimastr.com/redemption/rdo/RDOMail.htm

--
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 message ...
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, 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?


Ads