You can use the SentOnBehalfOfName property. See:

OL2000: How to Programmatically Set a Form's From Field:
http://support.microsoft.com/?kbid=232309

Eric Legault [MVP - Outlook]
MCDBA, MCTS (Messaging & Collaboration, SharePoint Infrastructure, MOSS 2007
& WSS 3.0 Application Development)
Collaborative Innovations
-> Try Picture Attachments Wizard For Microsoft Outlook <-
Web: http://www.collaborativeinnovations.ca
Blog: http://blogs.officezealot.com/legault

"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
24 Apr 2008Changing the sender's email address.RLN
29 Apr 2008\ Re: Changing the sender's email address.<elegaultZZZ@REMOVEZZ...
All times are in (US) Eastern Daylight Time (GMT -4:00)