Thanks for your prompt response
I have used the macro supplied by Ron (see below)
***************************************************
Sub Mail_workbook_1()
'Working in 97-2007
Dim wb As Workbook
Set wb = ActiveWorkbook
If Val(Application.Version) >= 12 Then
If wb.FileFormat = 51 And wb.HasVBProject = True Then
MsgBox "There is VBA code in this xlsx file, there will" &
vbNewLine & _
"be no VBA code in the file you send. Save the" &
vbNewLine & _
"file first as xlsm and then try the macro again.",
vbInformation
Exit Sub
End If
End If
On Error Resume Next
wb.SendMail "(e-mail address removed)", _
"CPCM DAILY REPORT"
On Error GoTo 0
End Sub
***********************************************
This works fine if I want to send it to once person. However I would like to
send it to 10 different people. Presently I have a distribution list set up
in Outlook with these 10 people. Is there a way that I can include the
distribution list in the Excel macro and if so , how?
Alternateivly, can I put all the email addresses in the macro so that it
goes to all of them?
If so how would I restructure the macro>
Thanks
John
__________ Information from ESET Smart Security, version of virus signature database 3960 (20090325) __________
The message was checked by ESET Smart Security.
http://www.eset.com