Automate

 View Only

  • 1.  Extract Distribution List Details Associated with Output Conditions

    Posted 12-10-2019 10:32
    ​Hello,
    We use Distribution Lists to organize and capture email recipients for our customer notifications (output conditions) of sales orders, billing & certificates of analysis.  Is there a way to pull the distribution list name, title, folder name, and email recipient(s) by customer number for each type of output.  I'm guessing this would start with the NACH table and then possibly link up to the SOOD, SOID tables & other structures to get the details.  Is this possible and if so, how?
    Thanks in advance.

    ------------------------------
    Mary Lynch | Data Analyst
    Cargill, Inc. | 952-742-6898
    ------------------------------


  • 2.  RE: Extract Distribution List Details Associated with Output Conditions

    Posted 12-10-2020 16:48
    Mary
    If there are ​tables and objects within the tables you can certainly query those.... it looks like you have a transaction only license, so I would suggest reaching out to the 2 Query license users at Cargill and create a bit of testing on those tables.

    Hope this helps.
    Bill

    ------------------------------
    bill wiseman | se
    Winshuttle North America | 83838383838
    ------------------------------

    Original Message