Sukhdev Singh
Member
Dear All,
Greetings for the Day!!
Hope you are doing well. I need your help to created email as an attachment to concern dept. wise.
1. I have created a macro which is creating the dept. wise file in a folder. (Already Created)
2. Now I wish to email that separate file to concern dept. head using mail through MS Outlook.
3. Summary of the each Dept. should be paste on mail body.
Need the help for point 3 & 4. Pls. guide me how can I do it. Your help is appreciated!
Thanks in advance. Excel Sheet is attached for your kind perusal.
Best Rgds,
Sukhdev Singh
Greetings for the Day!!
Hope you are doing well. I need your help to created email as an attachment to concern dept. wise.
1. I have created a macro which is creating the dept. wise file in a folder. (Already Created)
2. Now I wish to email that separate file to concern dept. head using mail through MS Outlook.
3. Summary of the each Dept. should be paste on mail body.
Need the help for point 3 & 4. Pls. guide me how can I do it. Your help is appreciated!
Thanks in advance. Excel Sheet is attached for your kind perusal.
Best Rgds,
Sukhdev Singh