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."

Ron de Bruin has the go to site for things like this
https://www.rondebruin.nl/win/s1/outlook/bmail2.htm

If you have issues after that, post the code you're using and we'll help troubleshoot it.

I didn't look at the site NoSparks suggested; I'm just bored tonight and thought I'd tackle a few of these. But if this task is for your own use, not for others, then you might be satisfied with a quickie that I use myself for a very similar activity. I have an Excel program that fills in a sort of time sheet for my employer; then it cuts a portion of the worksheet to the clipboard, opens and prepares an email (mostly the recipients' addresses and the email account to be used), and then stops. The cursor is at the top of the email; all I have to do is hit the Paste button to put the report into the email. Theoretically I could have the program do the paste, too, but that would require finding the right spot in the HTML code; for this once-a-week task I took the easy way out and just hit <Shift-Ins> at run time.

That doesn't insert the standard text you want, but it's a start. Interested?

Thanks, NoSparks. I found enough to get started.