Need to change "From" field in e-mail

[Guest]

I've inherited a report at work that uses the Docmd.sendobject method to
e-mail out reports that are generated in access as excel files.

Even though I have a message stating that the customers should talk to
customer service and not reply to the email they do anyway, and then i have
to forward their email.

I would to be able to change the code so that return e-mail address is our
customers service dept email address and not mine.

I looked up the syntax for docmd.sendobject and it doesn't have and argument
specified in the help for the 'from' field.

I'm thinking there must me some way to do this?


--
Billy Rogers

Dallas,TX

Currently Using Office 2000

 

[Guest]

Is the email account that you are sending this email from suppust to receive
any email at all? I would suggest writing a procedure in the NewMail event in
Outlook to reply with an email let the sender know not to send the email to
this address and then forward the original email to the approriate place.

Good Luck

Keith