Excel workbook email macro not working

Hi buran,

I am getting the error on the following line:

.To "jfarr3ll@XX.com"

the error is:

Run-time error '-2147352567 (80020009)':
The object does not support this method