Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

how to create and xls spreadsheet with 400 unique password and then email each user only their password

Posted on 2014-07-23
3
Medium Priority
?
252 Views
Last Modified: 2014-07-23
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.
0
Comment
Question by:msidnam
  • 2
3 Comments
 
LVL 9

Expert Comment

by:skipper68
ID: 40215107
Do you have restrictions as to what the password has to contain?  Uppercase, lowercase, numbers, special characters, minimum length, max length, etc.?

In a quick example, you can use VBA code in Excel to generate random passwords
Public Function RandomizeF(Num1 As Integer, Num2 As Integer)

Dim Rand As String
Application.Volatile
getLen = Int((Num2 + 1 - Num1) * Rnd + Num1)
Do
i = i + 1
Randomize
Rand = Rand & Chr(Int((85) * Rnd + 38))
Loop Until i = getLen
RandomizeF = Rand
End Function

Open in new window


Then, you can use mail-merge with Exchange\Outlook to automatically email the passwords to the users.
0
 
LVL 9

Accepted Solution

by:
skipper68 earned 2000 total points
ID: 40215170
You can also use the trial of KuTools for Excel which is fully functional for 45 days.  It does password generation.
Generate Strings
0
 
LVL 2

Author Closing Comment

by:msidnam
ID: 40215352
Excellent. Thank you.
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

As a Microsoft Exchange user, you must have known the importance of an Offline storage table (OST) file. It is nothing new for an Outlook user to be dependent on a .ost file during a server break down or a problematic Internet connection. In such a…
Often, the users face difficulty in accessing Outlook 2016 PST files on Windows 10 computer. One of the reasons behind it is the improper functioning of MS Outlook when the user tries to open it. MS Outlook suddenly stops working, or it will not op…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…
Suggested Courses
Course of the Month13 days, 23 hours left to enroll

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question