I send e-mails daily and provide specific information from an attached
spreadsheet from select cells within the same spreadsheet. I would like to
write code that would concatenate the information together in an e-mail,
automatically filling in the subject lines and sending.

Here is what the process would be like:
1. I open the spreadsheet attachment. Check cell A1.
2. Close the spreadsheet attachment.
3. Forward the e-mail; the subject line remains the same.
4. The message is something like: "Your information is " & Cell A1
5. I would also need to format the information that was added using a number
format.

Any ideas?