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