I need VBA that will copy the UsedRange of a worksheet into the body of a new Outlook email, preceding with multiple lines of introductory text as shown below. Thank you!



This report captures all audits in the reporting phase or with a planned report date in the next 30 days.
Data for this report is pulled as of 8:30 each morning.

Updating Archer
Status Comments: Begin each status comment with the date followed by a colon. Example: "5/10/18: 2 potential audit issues could lead to IN rating."