Attach new excel automatically with file format change through outlook

[Ravipoojari]

Hello All,

I have a excel file which contains some data imported through database and some macros. Can you please assist in some VBA code which will send the copy of that file as normal without any macros and ranges from database through MS Outlook or help in changing the format of file from xlsm to xlsx while sending the same through outlook.
Please assist me and thanking in advance for your help.

Regards
Ravi

[gmr4evr1]

Try this, it will convert your sheet to an HTML and place it in the email body

Please Login or Register  to view this content.

If I'm not mistaken, you will need this function code as well...

Please Login or Register  to view this content.

I use this code in a UserForm so you may have to tweak some things here and there to get it to work properly. I tried to remove all the UserForm related stuff, by may have missed some.