that sends the whole workbook not the selected range.

--
Regards,
Tom Ogilvy

"Joshua Stollar" wrote in message
oups.com...
Workbooks(Index).Activate
ActiveWorkbook.SendMail Recipients:="", Subject:="",
ReturnReceipt:=True or False

Remember to have your default email program configured, it will also
ask/tell you that a program is trying to send mail without you doing
anything, just select not to tell/ask you again. That way it can
happen at night without any user interaction.