E-mailing through Outlook via Excel VB

[Greg Maloney]

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 ?

 

[Ron de Bruin]

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