I am trying to create a document in MS word that I can use to auto-generate logins and passwords for my users by just entering in a few details. The form looks like this (sample):
First Name: John
Last Name: Doe
The items that get auto-generated from the 2 fields above are below. Notice that it essentially uses the first letter of the first and last name to generate plus pre-defined letters/numbers that are appended or prepended:
Network Username: jdoe
Network Password: BRjd15!
Email Username: [email protected]
Email Password: BRjd15!
CRM Username: [email protected]
CRM Password: BRjd15!
Skype Username: jdoe.company
Skype Password: BRjd15!
Phone Username: [email protected]
Phone Password: BRjd15!
I know how to create the formulas in Excel, but I am looking for this to be more like a form for ease-of-use with Word. If anyone has any other suggestions besides Word, I'm all ears. Thanks!