Email Spreadsheet

mcartwri · May 9th, 2002, 01:52 PM

When a user closes the spreadsheet, it needs to save and automatically email to a certain recipient based on what they location they selected in a combo box that is in the spreadsheet.

Juan Pablo González · May 9th, 2002, 04:27 PM

Your doubt is how to run that code when the user closes the book ? or how to save ? or how to email the workbook ?

First.
Use the Workbook_BeforeClose event.

Two.
ThisWorkbook.Save

Three.
Depends on what mail system you're using.

May 9th, 2002, 04:27 PM	#2
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,927	Your doubt is how to run that code when the user closes the book ? or how to save ? or how to email the workbook ? First. Use the Workbook_BeforeClose event. Two. ThisWorkbook.Save Three. Depends on what mail system you're using. __________________ Regards, Juan Pablo González http://www.juanpg.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 9th, 2002, 01:52 PM	#1
mcartwri New Member Join Date: May 2002 Posts: 1	When a user closes the spreadsheet, it needs to save and automatically email to a certain recipient based on what they location they selected in a combo box that is in the spreadsheet.