Hi team need a help again.
I have a workbook with some 50 worksheets. each sheet has different name and there is a master sheet where the names are in a column and also the mail id against each sheet name.
Currently need a macro, where each worksheet is copied and pasted in a new workbook with shee tname as workbook name and send a mail with the workbook attached
request your help here.
Thanks in advance.
Regards,
Naveen
Hi TEam, Please help as i am unable to get thro
Mind readers we are not...We have no clue of what your setup is...So how are we able to assist...I have a workbook with some 50 worksheets. each sheet has different name and there is a master sheet where the names are in a column and also the mail id against each sheet name.
See Top Yellow Banner
Also...Doesn't really seem you follow through with your posts as seen here...So why should we try and assist...
https://www.excelforum.com/excel-pro...-workbook.html
https://www.excelforum.com/excel-pro...l-value-2.html
Last edited by sintek; 05-22-2020 at 04:00 AM.
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks