Solved

Sharepoint "mailto" link from User Field

Posted on 2010-11-10
1
1,343 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
[X]
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
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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Sharrepoint 2010 DB size 2 52
SharePoint 2010 Versioning 2 57
sharepoint list help 2 46
automatic updating of an excel spreadsheet hosted by sharepoint 12 50
Last week I faced a strange issue recently, i have deployed SharePoint 2003 servers for one project and one of the requirements was to open SharePoint site from same server. when i was trying to open site from the same server i was getting authentic…
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…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

730 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