vba rtf string to plain text conversion

A

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top