The attached excel file contains a macro called "delete columns". The macro will delete a select group of columns. It will then move and copy the new data excluding the deleted columns to a new work book.
Could someone please add some code to the macro so the new workbook is then automatically saved as "member_database" and attached to an email. I will be manually entering a different email address each time the sheet is sent so the macro can stop at this stage.
I do not want to save any changes to the original workbook. If anyone can add a line to the macro which also closes the original workbook without saving. It would be a great help