need code to copy text from workbook and paste it in a new outlook message

[rammergu]

Hi,

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

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 "abc@xyz.com" in the TO field, "123@xyz.com" in the CC field & "This is a test message" in the subject field.

Is this possible?

[shg]

Please read the forum rules, post your question in the Programming forum, and use code tags.