Hi all,

I have created a ticketing system/issue logger with a userform. Users enter in the information on the Userform, and the data from their entry is logged on a single line in the spreadsheet. This is all working fine.

Userform Interface:
Userform Issue Logger.JPG

One of the fields is the "Submitted By" textbox. I would like them to enter their name, and have an email be sent to them with a summary of the issue they just logged. However, I want the "Submitted By" field to be filled with their name, not their email address. So that adds in another step. The name will go on the issue log spreadsheet, while the email address is used for the email summary.

My question is: Can I take the name they enter, find their corresponding email address, and then send them an email with a summary of the entered userform information?

My team isn't that big, so I would be able to have a hidden sheet with names --> email addresses. Maybe a VLOOKUP is what I am looking for?

It doesn't matter if they send themselves an Outlook email, or if I send them an Outlook email from my IT account.
Body of the email or attachment, whatever is easiest.

Kristen