Solved

Sharepoint "mailto" link from User Field

Posted on 2010-11-10
1
1,293 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

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

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…
We had a requirement to extract data from a SharePoint 2010 Customer List into a CSV file and then place the CSV file into a directory on the network so that the file could be consumed by an AS400 system. I will share in Part 1 how to Extract the Da…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…
This is a video describing the growing solar energy use in Utah. This is a topic that greatly interests me and so I decided to produce a video about it.

947 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now