Get firstname only from People or groups column

[peac3]

Hi All,

I am trying to send the email from the sharepoint by using the firstname only from group or persons column.

Let's say the fullname is John Smith.

Atm, in the email header it's showing like this:

Dear Smith, John,

Task has been assigned for you

I would like showing as below:

Dear John,

Task has been assigned for you

The column name called "Assign To"

The code looks like this:

Dear [%Current Item:Assign To%],

It looks simple but I can't crack it for few days.
Any help would be appreciated, Thank you...

 

[peac3]

ps: the email coming from a workflow in the list.

 

[ehaze]

When you are setting the [%Current Item:Assign To%], change the 'Lookup for String' data source to User Profiles. Then select First Name from the 'Field from source' box.

Doing this, more or less will query the User Profile data source, and you will want to query by your Assign To field.

If needed, I can post a more detailed how-to.

http://www.sharepointed.com/