Hi,

Firstly I have used your macro and it is amazing. Thanks to you!

I need the same macro but shall I request more requirements on the same.

Request if you can add a separate box for the email Subject line and Mail Body in the excel sheet itself so that it can pickup the same.