Pasting a range from an Excel workbook to Outlook sometimes doesnt carry formatting over

Hello,

I have a workbook that I've developed through recording macros as well as using published code (Ron de Bruin) that when the workbook is opened call's my sub procedures.

Please Login or Register  to view this content.

Basically it removes the old data from a sheet, re-connects to my data source (Access pass through query), formats the table after the data is returned, and then copies the table range and puts it into an email, sends the email, and then kills Excel.

The issue I'm having is that it worked initially, but now it puts the table range into the email without the formatting that I apply in Excel.

Any idea what might be occuring here?

Thank you!