Hello aravindhan_31,
The following macro module has been installed in the attached workbook. This will send the message body worksheet over in HTML to preserve the format and allow for more than 255 characters in the message body. An annoying problem of launching Outlook is once you "Quit" Outlook the instance you created still runs in the background as an independent program. After running your macro multiple times you, you have multiple instances of Outlook running. This macro takes care of that problem. Each instance the macro creates, it destroys. If Outlook is already open, the macro connects to it, but doesn't close and destroy this instance.
Email Worksheet List with HTML Body
Bookmarks