Skip to main content
Question

filter, save workbook and send email

  • January 25, 2022
  • 1 reply
  • 46 views

  • Cadet | Tier 2
  • 6 replies

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

Forum|alt.badge.img+19
  • Most Valuable Pathfinder
  • 2693 replies
  • January 25, 2022

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>

 


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings