Ooops. I forgot to mention that you need to explicitly reference the
MS Outlook library for the code I posted to be able to run by
selecting Tools | References from the VBE main menu and then select
'Microsoft Outlook 11.0 (or 12.0) Object Library' from the 'Available
References' list.
Best wishes
I am not quite clear exactly when you would like an email to be sent.
Is it when you change a cell in column A ('Subject Line') or when you
update an email address in column D. Anyhow here is code that you
could place in the VBA module associated with the worksheet you would
like to respond to chan
