[VBA/Macro/ How do I copy a range of cells and then paste that data in the CURRENT e-mail you are in on Outlook?

[booleanboolean]

Hi fellow coders,

I currently have a Macro that copies a specific range of cells and, with a click of a button (titled: Send E-mail), opens Microsoft Outlook with a new e-mail message with the information pasted in the body.

This is what I want to do:

1) In Microsoft Outlook, search for whatever e-mail thread I find, click "Reply/Reply All" which then gives me a new e-mail (reply thread) for me to paste my data in.

2) Press a Macro Button on Excel and have that macro copy my desired range into the above (current e-mail I am replying to.)

Can this be done? I have created two macros that a) copies data from excel, click macro button, opens Outlook with a a brand new e-mail and b) I created a simple "Copy" Macro button that copies the selected range to a clipboard, which then I go to my respective e-mail thread on Outlook and paste the data in there.

Please, any help would be appreciated. I'm almost done with this project and it would be SO beneficial to have it work the way I want to . Please reply with any advice or if you need anything from me.

Cheers!

 

[John_w]

instead of selecting a range of cells, is there any way to tell the macro to either: 1) Copy Cells you have manually selected yourself, or B) Copy the most recent cells entered ?

The first option is all there in my OP. Just comment out the Range Copy line and uncomment the Selection.Copy line.

I don't know about the second option.

 

[booleanboolean]

What do you mean by Comment and Uncomment?

 

[booleanboolean]

Never mind, I got it. THANKS!