I have an Technical Service Request InfoPath form and an email alert needs to be sent to two users each time that the form is completed and submitted to a library. An email alert needs to be sent to our technical manager which is a relatively easy workflow to set up in SharePoint Designer. The other user which needs to be alerted is the engineer which could be one of six people (we only have one technical manager).
The person completing the form will have to enter the name of the engineer to whom the alert should be sent to. I am struggling to send an email to this user. Is there a way to associate an email address with the name which is entered? We could use drop down lists and need to automate this in some way.
We dont need to retrieve full user information from AD but just need the email address of the user whose name is captured in a Text Box named 'Engineer'.
Any suggestions or assistance would be greatly appreciated,
View Complete Post