TASK_RTF_NOTES converting to String using VBA

[Amit01]

1. AmitK Aug 31, 5:01 pm show options
Newsgroups: microsoft.public.project.vba
From: "AmitK" <[email protected]> - Find messages by this author
Date: 31 Aug 2005 14:01:47 -0700
Local: Wed, Aug 31 2005 5:01 pm
Subject: VBA Project server to Outlook - TASK_RTF_NOTES conversion problem
Reply | Reply to Author | Forward | Print | Individual Message | Show
original | Remove | Report Abuse

I am writing a macro in outlook that gets the task information from
ProjectServer and saves it in the Outlook Tasks. The Task Notes are
stored as Image Fields in ProjectServer (TASK_RTF_NOTES). I try to cast
the TASK_RTF_NOTES to binary and then to varchar to get it as a string.
The problem is I get the string in this format where it displays all
the rtf meta data
{\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fswiss\fprq2\fcharset0
Arial;}{\f1\fswiss\fprq2\fcharset0 Arial Narrow;}}
{\*\generator Riched20 5.50.30.2002;}\viewkind4\uc1\pard\f0\fs16 Line 1
///\par
Line 2\par
Line 3\par
Line 4\b\i\f1\fs20\par

}

Is there a way in VBA to just extract just the following string
Line 1
Line 2
Line 3
Line 4

I could not find any solution in converting from the rtf string to
plain text. Please help..

 

[Rod Gill]

Hi,

Look at the prjdb.htm file that comes with Project (search for it). It tells
you how.

However, if you are using Project Server and your project is published, then
a much easier version can be found in the MSP_VIEW tables. See prjsrvr.htm
that also gets installed with Project for details on available View tables
and fields.