By using listi.net you agree to our cookie policy, We and our partners operate globally and use cookies, for multiple purposes

listi.net

 


SendChecklist_email() - udf - sends a formatted email as a checklist to proper person to dbl check report

Pre-steps
  • Copy the email to word
  • Save as html
  • Open page in browser
  • view source
  • save the source
  • Modify the source and added
    • {filetoref}
    • {fiedisplayname}
    • {slides}
    • {whattogen}




    Algorithm
  • if it's not me then exit bc I reserve this functionality for myself (IP)
  • Inputbox - get link for evidence if neeeded
  • Based on the active sheet
    • MLPFS
      • save the 4 params


    • Swap Dealer Quarterly

    • Others
    • Special processing
  • Format the email
  • Send the email to yourself so you can check it
  • Askuser if email is ok
    • send it
  • There was a long and a short form checklist that had different processing
  • Different files could be attached based on what was being run
  • Replace the {xxxxxx} in the file with the actual value
  • Send it to the user
  • Files could be passed seperated by ";"
    • blog comments powered by Disqus