Send Email depending on Cell Value

[Guest]

Hi,

I am trying to create a Macro that sends a workbook as an e-mail to
different persons depending on the value in a specific cell.

I have not yet achieved to do this. Would appreciate some suggestions on how
to do this.

 

[Norman Jones]

Hi Tomas,

Ron de Bruin has an extensive range of example email procedures at:

Example Code for sending mail from Excel
http://www.rondebruin.nl/sendmail.htm