Sharepoint "mailto" link from User Field
Posted on 2010-11-10
I have a workflow that collects various data from custom fields and sends it out in an email.
I have one field called Buyer, which is a user lookup field. When I use the field within the email, it returns DOMAIN\username - how can I strip the "ULTRA\" from this and add our email suffix "@company.com"?
The end result would look like: email@example.com - essentally, I want to include it in a mailto link.
Assuming that this is possible, I'm guessing i would need to build a dynamic string to do this, but I am unsure of the operators I need to use.
Please advise :)