I need my VB app to iterate through the items in the Outlook/2000 Contact folder, and save these items to a SQL database (via ADO). These records will be read back later and re-inserted into a different Contacts folder.
My idea is to save the entire Contact item in one go (instead of field by field).
Is the contact item object a fixed size? Can I just stuff the whole thing into a single SQL field for later retreival?
If:
Dim objEntry As Outlook.AddressEntry
Dim rs as ADODB.Recordset
Could I do something like:
rs!fullEntry = objEntry
where fullEntry is a field the exact same length as an Outlook AddressEntry object?
-with thanks,
Mike
My idea is to save the entire Contact item in one go (instead of field by field).
Is the contact item object a fixed size? Can I just stuff the whole thing into a single SQL field for later retreival?
If:
Dim objEntry As Outlook.AddressEntry
Dim rs as ADODB.Recordset
Could I do something like:
rs!fullEntry = objEntry
where fullEntry is a field the exact same length as an Outlook AddressEntry object?
-with thanks,
Mike
