Create macro to send worksheet as body of email using cells as subject line

Hi,

I would like to send the data in a worksheet as the body of an email to outlook (not an attachment). The email will always only go to the same email address and I would like the subject line to reflect the data from cells E20 & R20 (FYI: cell E20 will be client's first name and cell R20 will be client's last name). I would also like the formatting to stay as it is in excel.

Any help would be great!

Thanks

Hi Linda

See this link...it addresses your issue. If you need help adapting let me know.
http://www.rondebruin.nl/mail/folder3/mail4.htm

Thanks! That is perfect. I've adapted the code to what I want. However, I do have a couple of issues if you can help. The first is, I don't know how to get the subject line to be the data in cells E20 & R20. Below is the section of code I've used for the subject line:

Please Login or Register  to view this content.

The second issue I have, is that most of the sheet is is protected so that the user can hit tab and it automatically goes to fields that they need to fill in. I saw a bit in the link you gave me about the sheet needing to be unprotected and that you can write this into the macro. However, I didn't understand how to do that part. Is it possible? The protection on the sheet doesn't necessarily need to be password protected if that helps.

Thanks for your help so far!

Hi Linda

For this

subject line to be the data in cells E20 & R20

try

Please Login or Register  to view this content.

For this

the sheet needing to be unprotected

it's as simple as this

Please Login or Register  to view this content.

However, were it me I'd Google "protect user interface excel vba". It allows code to run on a protected worksheet.

You're welcome...glad to be of help.