Send Outlook email From-field (Office 2003)

I have an application in VBA (in Excel) that sends emails to a list of users. This year, I'm managing two email accounts in Outlook and I want to "set the 'From:' field" programmatically.
I'm using something like

Re: Send Outlook email From-field (Office 2003)

OK, I'm working with OL2003 and and Exchange server so I guess I should/could use the "SentOnBehalfName" property... Tried it and I simply don't know how to... Also can't find and example anywhere on the net (I Googled for that name but only see people telling others to use it but not HOW to use it)... sorry for my ignorance here. Appreciate your help.

Re: Send Outlook email From-field (Office 2003)

I assume that you have an object of type MailItem, let's say objMessage, and that you have code of the form
<code>
With objMessage
...
End With
</code>
Somewhere between With ... and End With, insert a line like
<code>
.SentOnBehalfOfName = "John Doe"</code>