Copy a formatted table from excel sheet to outlook meeting request.

Hi All,

I have the below macro code which automatically sends the meeting requests from excel using outlook it works fine but I need to put some data as well on the meeting requests body when I am sending the meeting requests. my code copies the data as well on my meeting requests body but if my worksheet has a datatable with formatting then it just pastes the data with out any formatting. I am using dataobject method to copy the data to meeting body from excel sheet. I am using outlook 2003 so I can't use HTML method as Outlook 2003 doesn't support HTML for meeting requests. Below is my code :

Please Login or Register  to view this content.

I have attached my macro file as well. Please have a look.

Thanks a lot for your help in advance.

Hi romperstomper,

Thanks, I will ensure the same going forward.

Cross posted here: http://www.mrexcel.com/forum/showthread.php?t=506949

Thanks a lot for your help in advance.

Abhay