Email on selection of criteria -2

[Thomas Kuriakose]

Dear All,

This is with reference to the previous post on email of excel file. I copied codes from mrexcel.com and now getting Compile error, " Sub or function not defined".

Please find attached the file for your reference.

Also, we need different recipients in to and cc based on the selection at column Y.

kindly help.

thanks,

with regards,
thomas