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.