You can use the SentOnBehalfOfName property. See:
OL2000: How to Programmatically Set a Form's From Field:
http://support.microsoft.com/?kbid=232309
"RLN" <RLN@discussions.microsoft.com> wrote in message
news:5924E518-DA95-436D-AE78-EECCEDC07DFB@microsoft.com...
> RE: Outlook 2003/Access 2003
>
> I have an Access app used by several people in a department and it sends
> an
> email out twice a month. Right now I have the "SendMail" method of the
> "DoCmd" object in Access sending the email. Problem is, that method in
> the
> Access object does not let me change the "From:" address before sending
> the
> email. It will only use the address of the person using the app as the
> 'sender' for emails.
>
> I need to change the "From" address changed to an internal dept address
> before the email is sent. I'm not sure exactly how to do that using the
> Outlook object. (newbie to the Outlook Object)
>
> If someone has a very simple example of how to invoke the Outlook object
> can
> be used in Access and set up a simple email where the "Sent From" can be
> changed, I would appreciate it.
>
> If there are some good tips sites you'd recommend for usaing the Outlook
> object inside of Access, please include them.
>
>
> Thank you.
>
> -------
> RLN