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