Email Generation / Password Distribution

This file goes hand-in-hand with some of the other functionality discussed.  If we're using our encryption / decryption logic, we need a simple way to distribute the unique PINs to the various users.  That's where this file comes it.  You only need to populate 2 columns, and the email generated is very generic - but it does the trick. 

What makes this file unable to work cohesively with the Breakout Data file is the fact that I do now know what naming convention you've chosen for your Breakout files.  We can update the code to auto-attach your file, but that require some additional work.  Rather than having your populate hundreds or thousands of columns manually in this file, it's far simpler to simply coordinate with us on the front-end.  We can capture the file names used in the Breakout Data file, and populate the specific attachment names in this file for a more seamless process.  It's also completely possible to customize the email and make it more specific to your individual process.

Please reach out for any additional functionality.  In the meanwhile, I hope you find this file serves its purpose and saves you some time.

generate_emails.xlsb
File Size:	33 kb
File Type:	xlsb

Download File

---