I am attempting to use the following code to send an email through outlook from excel with 2 cells and a range of cells as the message body and attach multiple files to the email if they exist on the hard drive.

Please Login or Register  to view this content.
Many parts of this work and don't work depending on what i choose.

The below code creates the message body as blank if i include the range Sheets("OLDEST CALCS").Range("B6:I28").Value but if left out it creates the message body correctly.

Please Login or Register  to view this content.
I would like the below code to go through a specified folder and attach all files that start with a given number. the different files have completely different names but the ones i want to attach will always start with a number 1

Please Login or Register  to view this content.