Headscratcher-
I'm trying to include a message into the body of the email (I've got the subject line). I'm not using Outlook as my source of distribution (Groupwise). This is what I have so far. Does anyone have any suggestions?
Sub UpdateClause()
'
' UpdateClause Macro
' Macro recorded 06/11/2008 by bkyarbro
'
'
Dim MyArr As Variant
MyArr = Sheets("Sheet1").Range("P6:P6500")
ActiveWorkbook.SendMail MyArr, _
"Test"
End Sub
I'm trying to include a message into the body of the email (I've got the subject line). I'm not using Outlook as my source of distribution (Groupwise). This is what I have so far. Does anyone have any suggestions?
Sub UpdateClause()
'
' UpdateClause Macro
' Macro recorded 06/11/2008 by bkyarbro
'
'
Dim MyArr As Variant
MyArr = Sheets("Sheet1").Range("P6:P6500")
ActiveWorkbook.SendMail MyArr, _
"Test"
End Sub