I found some useful mail code on Ron DeBruin's site recent.

http://www.rondebruin.nl/pdf.htm

Look for Function RDB_Mail_PDF_Outlook

"Rammergu" wrote:

Hi,
I'm new to macro. I've created a control button and assigned it a
macro as per below to copy text.

Code:

Sub COPY()
'
' COPY Macro
'

'
Range("B4:K23").Select
Selection.COPY
End Sub

i need the functionality to extend this code.

i want it to copy open a new outlook message paste the copied
content in the body of the message.

insert " in the TO field, " in the CC field &
"This is a test message" in the subject field.
I dont want the email to be sent, but rather to be displayed.