Compressed Richtext Fields

Status
Not open for further replies.

phillfri

Member
Does anyone know how to read the compressed richtext fields from the BCM 2010 database using SQL from Excel? I managed to retrieve user defined binary fields from the database, but can't seem to find any way to decompress the note fields from various forms, which appear to all be stored as compressed richtext.
 
To uncompress PR_RTF_COMPRESSED, use WrapCompressedRTFStream MAPI function

(returns back uncompressed IStream).

Dmitry Streblechenko (MVP)

-

"phillfri" <phillfri.43jynm@invalid> wrote in message

news:phillfri.43jynm@invalid...

> Does anyone know how to read the compressed richtext fields from the BCM
> 2010 database using SQL from Excel? I managed to retrieve user defined
> binary fields from the database, but can't seem to find any way to
> decompress the note fields from various forms, which appear to all be
> stored as compressed richtext.

> > phillfri
> >
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
I Outlook on Windows Phone - compressed images .emz Using Outlook 0
C View doesn't refresh (fields or formatting) Using Outlook 1
M Accessing ALL Outlook contact fields Outlook VBA and Custom Forms 3
Z Import Tasks from Access Using VBA including User Defined Fields Outlook VBA and Custom Forms 0
J Read Outlook Form fields Outlook VBA and Custom Forms 3
G Other users can't see P.2 with custom fields in Form Outlook VBA and Custom Forms 0
S Reference Custom Fields with VBA Outlook VBA and Custom Forms 2
J Outlook 2013 Change color of text in data fields of contacts in Outlook 2013? Using Outlook 10
S User Defined Fields adding new value (2) Using Outlook 0
M vCard does not have user-defined fields from my custom contact form (365) Using Outlook 1
T Outlook 2010 Correct way to map multiple contact fields Using Outlook 4
F Appointment Show All Fields Using Outlook 1
F MAPI, User Defined Fields and perspective after 20 years Outlook VBA and Custom Forms 0
B Outlook Business Contact Manager with SQL to Excel, User Defined Fields in BCM don't sync in SQL. Can I use VBA code to copy 1 field to another? BCM (Business Contact Manager) 0
E To convert imported data to custom fields in Task list Outlook VBA and Custom Forms 1
cimbian street address fields contain 0A0D Outlook VBA and Custom Forms 2
S Custom user fields in received messages Outlook VBA and Custom Forms 1
J Backup .OST - Custom Contact Forms, Defined Fields, Notes Using Outlook 1
P Outlook custom fields "events" Using Outlook 0
J Add Fillable Fields to Existing Template Outlook VBA and Custom Forms 1
B Customize contact record phone fields Using Outlook 2
G Addition of 2 fields based on checkboc true or false Outlook VBA and Custom Forms 2
M Multiple User Defined Fields that can be added, changed, updated using VBA and user form Outlook VBA and Custom Forms 0
R User Defined Fields adding new value Using Outlook 3
S VBA with User Defined fields Outlook VBA and Custom Forms 9
Diane Poremsky Add Attachments and Set Email Fields During a Mail Merge Using Outlook 0
O VBA to extract email (fields and body) to Excel Outlook VBA and Custom Forms 14
H How to export *all* fields from Outlook Using Outlook 2
L Change the displayed fields in calendar view Using Outlook 1
N Export Outlook custom forms fields to excel Outlook VBA and Custom Forms 1
M Recurrence and custom fields Outlook VBA and Custom Forms 0
Diane Poremsky Hiding Global Address Book Fields Using Outlook 0
M Map Outlook user defined fields onto a Sharepoint list ??? Outlook VBA and Custom Forms 1
L Copy email body fields to excel Using Outlook 0
Diane Poremsky Add attachments and set email fields during a mail merge to email Using Outlook 0
H User designed fields not usable in contact folder views Using Outlook 0
L Outlook 2007 Search All Fields in Contacts Using Outlook 1
N How to retrieve user defined fields values to bcm form. Using Outlook 2
N How to disable user defined fields in BCM forms Using Outlook 2
M Adding fields to Task in Outlook Home and Business 2010 Outlook VBA and Custom Forms 7
W Meeting printing background fields Using Outlook 0
N Outlook 2013 vs Outlook.com Email Address fields Using Outlook.com accounts in Outlook 1
S Fields in BCM are overlapping BCM (Business Contact Manager) 2
U Cannot access fields at bottom of Outlook 2013 Contact Rec. Using Outlook 1
C Outlook Custom Contact Form Attach Files in new notes fields Outlook VBA and Custom Forms 3
K User Defined Fields in Outlook 2010 Using Outlook 2
S Custom Outlook Form 2013 Displaying fields incorrectly Outlook VBA and Custom Forms 1
J Do fields in Outlook have ID's? Using Outlook 1
M Predefined Outlook Fields not available to add into a BCM record BCM (Business Contact Manager) 0
A phone numbers fields in BCM are not correct BCM (Business Contact Manager) 3

Similar threads

Back
Top