Fields needed for importing, and exporting Null fields

A

Adam Ruben

(apology for cross-posting--I think I posted this in the wrong place first)

I'm building a feature to export contacts to Excel. My form has 291
properties (including nearly 100 user properties), too many rows for Excel
so I have to cut some. I'm using Outlook 2002. There are many built-in
properties (fields) I've never heard of that seem easy to drop, but I want
to preserve all fields necessary to import this file into a different copy
of Outlook and have it work ok. Can I skip fields like Application, Session,
Outlook Internal Version, Parent, FormDescription, GetInspector,
MessageClass, NoAging, IsConflict, Actions, Saved, Journal, UserCertificate,
UserProperties, and ItemProperties? What about ones that sound like they're
really for mail messages, like conversationIndex, ConversationTopic,
DownloadState, or MarkForDownload?

Also, in exporting, certain fields are hanging up the export routine and
causing errors (e.g. Type Mismatch). For example, ReferredBy, which in the
Locals window shows up as having value <> rather than "" as most text fields
do (same problem with email fields). Is that a symbol for Null? For these
fields do I need some other syntax to export them than
Item.ItemProperties.Item(fieldname).Value?
 

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