Notifications
Clear all
VBA & Macros
2
Posts
2
Users
0
Reactions
54
Views
Topic starter
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.
Posted : 16/09/2016 6:14 am
Hi Sarfraz,
Have you looked at this
The sheet is attached as a PDF, as you have to save the sheet as something, maybe a PDF or a workbook.
Phil
Posted : 16/09/2016 8:06 am
