Hi there,

Relatively new to VBA so this is proving quite a challenge for me.

Does anyone have a simple VBA code to Copy a cell (in this case A111), open Outlook, paste the cell contents into the body of the email and add an email address and subject?

I have found a code that seems to open the workbook into an email format, but is within excel. I need this to paste the data into an outlook email.

Any help would be greatly appreciated!

Thank you