Do want to send a new workbook with 3 sheets of data?
Where's the email list?
yes different workbook for each branch. And list of email attached. and want to automate sheet change through loop not with name till last sheet.
Do want to send a new workbook with 3 sheets of data?
Where's the email list?
yes different workbook for each branch. And list of email attached. and want to automate sheet change through loop not with name till last sheet.
Thanks Alot It is working only mail is not work and one more thing can we automate sheet change like if in any file i have sheet more than this 3 than how can automate to change the sheet with loop.
yes different workbook for each branch. And list of email attached.
Please help me from this file i want to create a separate files of branch with all sheets and i want to sent that to separate in mail on defined list mail id.