VBA Project server to Outlook - TASK_RTF_NOTES conversion problem

[AmitK]

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

 

[Mike Glen]

Hi Amit,

Try posting on the developer newsgroup as this one's closing down. Please
see FAQ Item: 24. Project Newsgroups. FAQs, companion products and other
useful Project information can be seen at this web address:
http://project.mvps.org/faqs.htm

Mike Glen
Project MVP