Dear Sir,
How to email active excel sheet as attachment but name of sheet should same as given for excel sheet.
Eg : If I have 10 Excel worksheets in my workbook and I wanted to send sheet “ABC” which is active now I wanted to attached sheet “ABC” in my outlook but attachment name should show as “ABC” only.
______________________________________________________________
How to email active excel sheet as attachment but name of sheet should same as given for excel sheet.
Eg : If I have 10 Excel worksheets in my workbook and I wanted to send sheet “ABC” which is active now I wanted to attached sheet “ABC” in my outlook but attachment name should show as “ABC” only.
______________________________________________________________
Mod edit : thread closed as duplicate on one of VBA Macros forum