Automail from Outlook through Excel Macro

[Sanket_Ahirekar]

Dear All,

Need a help on sending auto mail from outlook. Please find attached copy of Excel macro for sending auto mail from outlook. Whenever I input big mail body in a column it shows some error but whenever mail body is less, it is working fine.

Can some help me in resolving this issue.

Thanks & Regards,
Sanket Ahirekar

 

[Chihiro]

So what is the exact error message and what line is highlighted in yellow when you debug?

Also, how big is the big email body that gives error.