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
239 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 500 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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
Many people use more than one email account and so it becomes difficult for them to manage them when they use separate accounts,  so, in this article, I have shared an easy way to add Other Mail Accounts in your Google Inbox. It helps to combine all…
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

825 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