Hi,

I have VBA code which is sending a sheet from excel as the content of an email. I want to amend this code so that instead of copying a cell range into the email, I want to be able to pick specific cells, write my own manual text into the code as well as insert line breaks. For example, cell A1 contains a person's first name, cell A2 is their last name, cell B1 is their birthdate, etc. So instead of the code just being the data from these cells, I want to also type the explanation (i.e. "First Name") and insert line breaks, so that it will appear like so in the email:

First name: Cell A1 data
Last name: Cell A2 data
Birthdate: Cell B1 data

At the moment I just have a range of cells selected. Here is the code for this section:

Please Login or Register  to view this content.