In the email message that will be sent as the alert, link to a specific field of the item that generated the alert.

Question: I want to link to a field in the item in a alert message: We see that it is standard functionality that one can link in the message to the item itself. In the message that will be sent in the alert we want to link to a specific field of the item that generated the alert. Is this possible?

Answer: The Alert Plus Message Templates allow you to insert special tags in the body of the HTML-based email template. These special tags are replaced with Alert List column values and other constructs when the message is created (at runtime).

The format and function of these tags are as follows:

• {sitelink} : Inserts a link to the Site containing the Alert List. 
• {itemlink}: Inserts a link to the Item that generated the alert. The link construction method is dictated by the contents of the External Host Path and Item View Link fields on the Mail Format - Options tab.  
• {subject} : Inserts the contents of the E-mail Subject field. (Only used in the Message body.)
• {[Column Display Name]} : Use any Alert List column name to have the Item value for that column inserted. For example: The token {Title} will insert the Item Title value into the message.
• {[Column Display Name]/Old} : Use any Alert List column name to have the Item value for that column inserted. For example: The token {Title/Old} will insert the Item Title value into the message.

To use a special content token, simply type the desired token(s) directly into the message body or subject fields. When you include a token for a column of type hyperlink, the text in the email message will appear as a hyperlink.

If you have a lookup in your Alert List to another list, you can use the Custom Item Link to override the URL in the {itemlink} token so the end user clicking on it will go to the item in the lookup list. This applies only if your lookup column stores the ID of the item in the other list. You can ue the Custom Item Linkand build the URL for the other list and add a query string on the end - like this:

http://myservername/SiteDirectory/mysite/blog1/Lists/Posts/Post.aspx?ID={ID}

Where the Posts list is list where my lookup comes from.