Question

filter, save workbook and send email

  • 25 January 2022
  • 1 reply
  • 38 views

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.


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.

 

https://developer.automationanywhere.com/blog/quicktip-connect-to-an-excel-spreadsheet-as-a-database/p>

 

https://www.youtube.com/watch?v=aXPIAmpbe0c/p>

 

Reply