Update available that introduces support for HTML in e-mail notifications for Project Server 2003 (885262)

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: 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

1. Start SQL Server Enterprise Manager.
2. Expand Microsoft SQL Servers, expand SQL Server Group, expand the appropriate server, and then expand Databases.
3. Expand ProjectServer, and then click Tables.
4. Right-click the MSP_WEB_CONVERSIONS table, point to Open Table, and then click Return all rows.
5. 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 <A href="^4/Notifications/Self_Notifications.asp">^4/Notifications/Self_Notifications.asp</A> 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 <A href="^4/Notifications/Mgr_Notifications.asp">^4/Notifications/Mgr_Notifications.asp</A> and clear the check boxes for resource task reminders.\n\n

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 "Notifications and Reminders" 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: