Excel WorkSheet Pasted Into Outlook

**dthhal** · 07-31-2009, 06:47 PM

Hello Everyone,
I am new to VB and am having trouble figuring out how to paste an Excel Worksheet into Outlook. I am using '07 versions for both.
I currently have code that when a button is selected, Outlook opens and has form text that I have entered. I just cant figure out how to get the worksheet pasted into the body of the email after this text. Any help would be so much appreciated. Here is what I have:

Please Login or Register  to view this content.

**Leith Ross** · 07-31-2009, 07:27 PM

Hello dthhal,

Welcome to the Forum!

The worksheet has to either be sent as an attachment or converted to HTML to be included in the email body. However, if the recipient doesn't have Outlook, the workbook won't display like you want or not at all. I don't have Outlook 2007 so I can't guide through the steps.

Maybe this link will help Mail one worksheet

**dthhal** · 08-02-2009, 01:08 AM

Leith,
Thank you for the warm welcome, and thank you for the link. I had in fact looked at this code prior to my post. I wish I could just figure out how to merge the 2 codes together. I really like what I have now, if I could only figure out how to add the send one worksheet code to it I would be all set. I'll keep working on it. Thank you again.

**dthhal** · 08-03-2009, 11:44 AM

I was able to add text to the body of my message using:

AdditionalText = AdditionalText & Range("cell")

Then, in the body, call out the additional text.