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

**rammergu** · 03-18-2009, 04:18 AM

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

Please Login or Register  to view this content.

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?

P.S I think now i've used the codes as per the forum rules.

**rammergu** · 03-18-2009, 11:38 PM

Hi,

requesting anyone out there to kindly assist me.

Kind regards,
Ram

**LordMarcus** · 03-19-2009, 12:40 AM

Hi,

If you want to send an email using VBA Excel, you can read on this: http://www.excelforum.com/excel-prog...ng-emails.html

Cheers,

**rammergu** · 03-19-2009, 07:36 AM

hi lord marcus,

i visited the site you suggested, however i could'nt understand most of the code plus, the requirement is different than mine, hence i cant pick the code straight away.

i've seen many other send to email codes and tried to comprehend if i could use any of the code from there, but no luck.

i dont want to send an attachment, just copy a range of data from worksheet and paste it in the body of the outlook message. fill out the recipients fields and lastly just display the message and not send it.

Kind regards,
Ram