?
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
?
247 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

Outlook for dependable use in a very small business   This article is about using the Outlook application (part of Microsoft Office) in a very small business, or for homeowners where dependability and reliability are critical requirements. This …
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
Suggested Courses
Course of the Month13 days, 8 hours left to enroll

801 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