I want to copy an Excel spreadsheet and paste it into the body of an Outlook
message using VBA code. I have the rest of the code working to create the email,
address it and send it, but I can't figure out how to access the Edit -> Paste
Special method.

If I do it manually, I go to Edit -> Paste Special, and when the Paste Special
dialog box comes up, I select the Paste option and As: is Microsoft Excel
Worksheet. Then click OK.

I want to be able to do this programmatically. Can anyone tell me how?