How to send on behalf of using VBA
 

I have a need to automate sending of email messages in outlook using data
from access. I've gotten everything down except for how to change the from
field to send from somone "on behalf of" We are using outlook 2003 and an
exchange server. I took a look at Eric's response on 6/4/07 and I am still
stupmed. I cannot give send as permissions only "on behalf of permissions"
for certain reasons. If anyone could shed some light on how to do this I
would greatly appreciate it.

Regards,

Bob

How to send on behalf of using VBA
 

Use the MailItem.SentOnBehalfOfName property.

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


"Bob Fishel" Bob Fishel @discussions.microsoft.com wrote in message ...
I have a need to automate sending of email messages in outlook using data
from access. I've gotten everything down except for how to change the from
field to send from somone "on behalf of" We are using outlook 2003 and an
exchange server. I took a look at Eric's response on 6/4/07 and I am still
stupmed. I cannot give send as permissions only "on behalf of permissions"
for certain reasons. If anyone could shed some light on how to do this I
would greatly appreciate it.

Regards,

Bob

How to send on behalf of using VBA
 

Of course it's something simple like this. Well Thanks very much this works
perfectly!

"Sue Mosher [MVP-Outlook]" wrote:

Use the MailItem.SentOnBehalfOfName property.

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


"Bob Fishel" Bob Fishel @discussions.microsoft.com wrote in message ...
I have a need to automate sending of email messages in outlook using data
from access. I've gotten everything down except for how to change the from
field to send from somone "on behalf of" We are using outlook 2003 and an
exchange server. I took a look at Eric's response on 6/4/07 and I am still
stupmed. I cannot give send as permissions only "on behalf of permissions"
for certain reasons. If anyone could shed some light on how to do this I
would greatly appreciate it.

Regards,

Bob