Hi,
The attached apeople excel file contains the email address and branch names.
1. I have to filter each branch name and save it in a new excel file.
2. I have to send the excel file saved in step 1, whichever e-mail address is in front of the branch in the Apeople excel file.
How can I do it? I will do this for 800k rows. I dont know how to do it in macro.