Email the Editor of an List Entry with Title of the Entry in Subject of the Email

tomdotcom
tomdotcom used Ask the Experts™
on
Hi

We have a office sharepoint server 2007 which hosts a quite a basic list. Currently we are using Presence to display the Editor with which we are able to email him

My problem is that i cant figure out a way to populate the subject of the same email with the Title of the entry and also the body with the summary of the entry.
I tried with calculated columns based without success, i have tried excell calculations in it but guess those are the ones which dont work in SP :)

If anyone has an idea how to do this in with calculated columns (or any other way) i would appriciate it

just an example this is the excel version of the formula i am trying to implement in SP, ofcourse by using the column titles instead of cell values

=HYPERLINK("mailto:" & A1 & "?subject=" & A2 & "&body=" & A3, "Email This")
=HYPERLINK("mailto:" & A1 & "?subject=" & A2 & "&body=" & A3, "Email This")

Open in new window

Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Commented:
Hi tomdotcom,
If you can store Editor email in column as plain text (column must have type single text) then try my method.
I have put sharepoint list template in attachment. change file extension to .spt and upload it in your sharepoint server List Templates Gallery. After that you can create new list based on my template and see how it work
CalculatedHyperLinkExample.txt

Author

Commented:
wow, thanks a lot, it works,

although i do have an issue with Item with 2 words, not putting both in the Subject, and then body not working either at all, it only fully works with one word item or one word body (also with few words in the MailBody only the first one appears)

Author

Commented:
ok i kinda got it but not elegant at all

using few other calculated columns to replace spaces with %20, the issue is only one space can be replaced per column so there needs to be as many calculated columns as someone might have spaces, so not elegant at all for sentances

=IF(ISNUMBER(FIND(" ",Item)),REPLACE(Item,FIND(" ",Item),1,"%20"),Item)

that would be a new column refering to the original Item column, i would call that new column sCAL then each adidtional one would need to refer to previous one, as in sCAL1 refering above to sCAL instead of Item and so on and so on for as many spaces as needed

at least there is progress :)

im still kinda supprised SP doesnt have a more elegant solution to this
=IF(ISNUMBER(FIND(" ",Item)),REPLACE(Item,FIND(" ",Item),1,"%20"),Item)

Open in new window

Commented:
The best solution is is write event handler using visual stuido. Inside event handler you can fully control column content using power of c# or VB programning functions.

Another one variant is to write custom field using visual studio but it is more complicated
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial