I found the following example at http://www.rondebruin.nl/win/s1/outlook/bmail2.htm
on how to email an Excel range using the mail envelope in Excel VBA.
I need to email two separate ranges one under the other eg C16:D17 and C136:D165
How would I do this?
Note: The worksheet/range not have to be active when you run the code.
'Working in Excel 2002-2013
Dim AWorksheet As Worksheet
Dim Sendrng As Range
Dim rng As Range
On Error GoTo StopMacro
.ScreenUpdating = False
.EnableEvents = False
'Fill in the Worksheet/range you want to mail
'Note: if you use one cell it will send the whole worksheet
Set Sendrng = Worksheets("Sheet1").Range
'Remember the activesheet
Set AWorksheet = ActiveSheet
' Select the worksheet with the range you want to send
'Remember the ActiveCell on that worksheet
Set rng = ActiveCell
'Select the range you want to mail
' Create the mail and send it
ible = True
' Set the optional introduction field thats adds
' some header text to the email body.
.Introduction = "This is test mail 2."
.To = "firstname.lastname@example.org"
.CC = ""
.BCC = ""
.Subject = "My subject"
'select the original ActiveCell
'Activate the sheet that was active before you run the macro
.ScreenUpdating = True
.EnableEvents = True
ible = False