I'm a company trainer. Anytime a new hire class is starting with my company, we contain all their data in a spreadsheet, and we individually email them their usernames and passwords to the half-dozen systems we use.
With class sizes up to 25 this can take forever, even with an outlook template. I'm looking for a way to have trainers click on the cell next to the new hire's name and have vba open outlook, generate an email in format shown in the example file, and fill in each of the bracketed items with the specific cell values from that person's row of the table.
I can figure out the hyperlink stuff on my own if needed. Mostly I need help with the code that pulls the First name, email address, and usernames and passwords and formats the email in outlook. Ideally when the "send email" cell is selected.
Thanks in advance!
Bookmarks