Message in body of email??

[bkyarbro]

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

 

[Domski]

Hi,

This may be of interest to you:

http://www.excelguru.ca/node/90

Dom