Auto send an email attaching current workbook upon closing Excel

Originally Posted by bdhobbs1

First of all, is it possible to have both kinds of macros run at the same time when closing Excel?

Yes, both tasks can be performed on closing the workbook. Note that there can be just one handler for the BeforeClose event.
The event handler macro has to be put in the ThisWorkbook code module and the line on which the sub is declared needs to be read as:

Please Login or Register  to view this content.

otherwise Excel and VBA will not recognize the macro as the desired event handler and the macro will not be executed on closing your workbook.

Originally Posted by bdhobbs1

I'm stuck at Automatically sending an email that attaches the current workbook.

I have responded to this part and in that regard suggested some amendments to your code.

Originally Posted by bdhobbs1

I have already set up a macro that auto saves when closing Excel, that way if someone is in a hurry to leave work and they forget to hit save and just close it down, it will save.

You did not provide the code of this part but I think it can be easily merged to make both tasks run sequentially before closing the workbook. As I said, there can be just one event handler so merging is needed.
It could look like:

Please Login or Register  to view this content.

I see, in the end it could look like the code below.
Note that I've changed the code in a way that the workbook in which this code is running will be attached to the newly created email, rather than the active workbook, since the latter could be a not yet saved workbook, causing a run-time error.
Also note that both the macros SendEmail and SaveBeforeClose can be placed in either the ThisWorkbook module or in a standard module (but not in both modules at the same time).
The Workbook_BeforeClose needs to be in the ThisWorkbook module.

Please Login or Register  to view this content.

Glad it's sorted and thanks for letting me know.