> 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