filter, save workbook and send email

  • 25 January 2022
  • 1 reply


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.

1 reply

Userlevel 6
Badge +16

Hi @rojda dilan küpeli​ ,


Best Approach here is to use Excel as a Database, Checkout below links to get more insights on implementation.>>