Excel to Word to Outlook

[terencelwl]

Hi,

I am trying to email a table from Excel with all its original formatting via Outlook in RTF format. However, the macros that I have been using only uses HTML formatting, but my recipients can't read it because they are on BlackBerry.

Therefore, I was wondering if its possible to transfer the table from Excel into Word first, and then transfering over to Outlook, which will retain all of its original formatting. Is there anyone who can help me with a code that could possibly do this from a macro within excel?

Thanks, Your help is greatly appreciated!