E-mailing through Outlook via Excel VB
 

Hi all,

I have a routine set up whereby my report automatically e-
mails our suppliers with their performance stats. The
trouble is that all the responses are coming back to me
instead of the suppliers usual contact. Is there anything
I could write into the VB to remove, hide or amend
the 'From' line of the e-mail ?

E-mailing through Outlook via Excel VB
 

Hi Greg

I don't know if it is possible with Outlook
But with CDO you can do this
Click on the CDO link on this page
http://www.rondebruin.nl/sendmail.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Greg Maloney" wrote in message ...
Hi all,

I have a routine set up whereby my report automatically e-
mails our suppliers with their performance stats. The
trouble is that all the responses are coming back to me
instead of the suppliers usual contact. Is there anything
I could write into the VB to remove, hide or amend
the 'From' line of the e-mail ?