VBA send email macro

Hello,

Please see attached workbook showing a macro that already sends an email. I am struggling to figure out how to incorporate the part on the "Instructions" tab in the body of the email send to whoever. I am needing range A3:A8 on the "Instructions" tab to be in the body of the email with the highlights intact but I can not seem to think of how I can accomplish this. Any ideas?

Thanks!

You could try something like

.Subject = ws.Cells(26, 2) & vbNewLine & ws1.Cells(8, 1)

Where ws1 is you Instructions sheet.

I don't have outlook so can't test it myself.

I actually need the .Body part adjusted but I tried that in place of that part of the code and it did not work unfortunately.

Try this attached - note I have commented out all the file stuff

oops - can't get the help these days.

In what way did it not work.

Did it not send the mail, not add the newline??

It did not add the new line in the body of the email from the instructions tab.

Thank you!!