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

948 Steps to 6 Figures by Learning Excel-VBA and Other Skills



Step 715 - 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 ";"

    •    Table of Contents | Send us your feedback | © 2025 All Rights Reserved | Edit