Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Sharepoint "mailto" link from User Field

Posted on 2010-11-10
1
1,324 Views
Last Modified: 2012-05-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: username@company.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 :)
0
Comment
Question by:ultra-it
1 Comment
 
LVL 16

Accepted Solution

by:
quihong earned 500 total points
ID: 34104953
You can add a calculated filed/column to the list and then use that column in your workflow.

Here are the available functions - http://msdn.microsoft.com/en-us/library/bb862071.aspx
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A question that is asked often, is how to generate sequential numbers in InfoPath Forms. The best way to achieve this is to use a SQL database, along with a stored procedure and a web service to connect Forms Services to the DB. The first thing t…
Microsoft SharePoint Foundation 2010 and Microsoft SharePoint Server 2010 do not offer the option to configure the location of the SharePoint diagnostic trace log files during installation.  This can, however, be configured through Central Administr…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question