There are different types of mail objects, but all of them will email the open file, or a single sheet from it.

So, you don't have to worry about where the file lives.


I'm late for work, but the most basic one to lookup in Excel VBA help is "SendMail"

This example sends the active workbook to a single recipient.

ActiveWorkbook.SendMail recipients:="Jean Selva"