Posts by niteshvkjain

Its not working on the starting point it give De budging error.

Yes You are correct that PDF is better but in My report user can check edit and Share there below line team data. So i want that all to be in Excel with the single macro.

First i want to create temporary files branch wise than there is email id in Email sheet branch also mention for same want to mail to all those id there branch data than after delete the Temporary files.

No Its Different and i add a sheet contain mailing details also want to split branch wise and to mail branch team as well

I want to mail branch data to all mail id mention for branch by creating a temp file with Branch Name and Delete Automatically after mail sent.Please help to correct the error occurred during run a macro. Subject and Body Text also mention in Mail Sheet so need to be take from there.

Quote from royUK

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.