How to split and email the file based on a certain column

Leonid
Leonid New Altair Community Member
edited September 2021 in Community Q&A

Hello,

Often we have a need to:
1. Split one file into multiple files based on a certain column (branch).  The number of distinct branches changes from day to day.
2. Then email these files as attachments to the email addresses associated with each branch. Email address is included with the data.

How do we achieve the above in Automator? 

Thank you,
Leonid 

Answers

  • Lasse
    Lasse Altair Community Member
    edited September 2021

    Hi Leonid,

    I think this is possible in Automator, but could you tell the input and export fileformats (eg. xlsx)?

     

    Kind Regards

    Lasse