Microsoft KB Archive/885262

= Update available that introduces support for HTML in e-mail notifications for Project Server 2003 =

Article ID: 885262

Article Last Modified on 1/5/2007

-

APPLIES TO


 * Microsoft Office Project Server 2003

-





INTRODUCTION
This article describes an update to Microsoft Office Project Server 2003 where you can use Hypertext Markup Language (HTML) for e-mail notifications and reminders that are generated by Project Server 2003.

By default, Project Server 2003 uses plain text for e-mail notifications and reminders. Some e-mail clients may not display hyperlinks in e-mail messages if the e-mail messages use plain text. This update introduces support for HTML in e-mail notifications and reminders that are generated by Project Server 2003.



RESOLUTION
This update is included in the Project Server 2003 post-Service Pack 1 Hotfix Package: September 23, 2004.

For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

885254 Description of the Project Server 2003 post-Service Pack 1 Hotfix Package: September 23, 2004

After you install this hotfix, update the MSP_WEB_CONVERSIONS table with the appropriate HTML tags, and then set the value of the WADMIN_EMAIL_SEND_HTML field in the MSP_WEB_ADMIN table to 1. By default, Project Server 2003 uses plain text for e-mail notifications and reminders, and the WADMIN_EMAIL_SEND_HTML field is set to 0. When you set the WADMIN_EMAIL_SEND_HTML field to 1, Project Server 2003 uses HTML for e-mail notifications.

To update the MSP_WEB_CONVERSIONS table and to set the values correctly, follow these steps:

Update the MSP_WEB_CONVERSIONS table
 Start SQL Server Enterprise Manager. Expand Microsoft SQL Servers, expand SQL Server Group, expand the appropriate server, and then expand Databases. Expand ProjectServer, and then click Tables. Right-click the MSP_WEB_CONVERSIONS table, point to Open Table, and then click Return all rows. Modify each string entry in the CONV_STRING column that contains a link to include the appropriate HTML tags in each link.

Note Each link that is contained in a string is preceded by the following characters:

^4

For example, the CONV_STRING column contains the following string entry:

To turn off these e-mail reminders:\n\nIf you have set reminders for yourself, please connect to the Project Web Access Set my e-mail notifications and reminders page at ^4/Notifications/Self_Notifications.asp and clear the check boxes for task reminders.\n\nIf you have set reminders for your resources, please connect to the Project Web Access Set e-mail reminders for my resources page at ^4/Notifications/Mgr_Notifications.asp and clear the check boxes for resource task reminders.\n\n

Add HTML tags to the string so that it looks like the following:

To turn off these e-mail reminders:\n\nIf you have set reminders for yourself, please connect to the Project Web Access Set my e-mail notifications and reminders page at ^4/Notifications/Self_Notifications.asp and clear the check boxes for task reminders.\n\nIf you have set reminders for your resources, please connect to the Project Web Access Set e-mail reminders for my resources page at ^4/Notifications/Mgr_Notifications.asp</A> and clear the check boxes for resource task reminders.\n\n

</li></ol>

Set the values
Set the value of the WADMIN_EMAIL_SEND_HTML field in the MSP_WEB_ADMIN table to a value of 1. To do this:
 * 1) In SQL Server Enterprise Manager, right-click the MSP_WEB_ADMIN table, point to Open Table, and then click Return all rows.
 * 2) Change the value that is displayed in the WADMIN_EMAIL_SEND_HTML column to 1.
 * 3) Quit SQL Server Enterprise Manager.

For more information about e-mail notifications and reminders in Project Server 2003, see the &quot;Notifications and Reminders&quot; topic in the Microsoft Office Project Server 2003 Administrator's Guide. To obtain the Microsoft Office Project Server 2003 Administrator's Guide, visit the following Microsoft Web site:

http://www.microsoft.com/downloads/details.aspx?FamilyID=2f446940-147b-447a-b0d3-6088673a53a4&DisplayLang=en

Keywords: kbqfe kbhotfixserver kbbug kbfix KB885262

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.