I apologize for the cryptic subject. This is what i am hoping to do. We recently moved to a new email scanning vendor. While they do sync with our AD, they also want us to assign all of our users a "cloud password" just in case AD sync fails for some reason. They need us to upload an xls spreadsheet with specific columns (First and last name, email address, password, etc). I can easily fill out that spreadsheet. Where i am having the problem is creating a column with a unique password for each user and then the ability to email users individually with only their password.
I was hoping someone would have some suggestions.