I'll explain in detail what I'm trying to do...

What I would like to do is have a macro execute an action where a selection of cells are copied and pasted into the body of an e-mail in outlook. I've found several sources that give the code to make this happen, but I need this function tweaked a bit.

The reason why the above function is not enough is because I'd like to keep these e-mails together, as in, a string of "Replied To" e-mails. This worksheet is going to be used by several different people, and we generally keep replying to the most recent e-mail so that we can monitor progress as the values change.

Is there perhaps a way for Excel to check our outlook inboxes for the most recent e-mail that has a specific subject, and reply to that e-mail?