|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Search this Thread | Display Modes |
|
#1
December 20th 06, 12:14 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
Redemption MAPITable - how to deal with empty fields
I'm working in Access 2003 with a Redemption MAPITable object to obtain a
subset of Exchange's GAL (Address Book). In the following code that I have written for test purposes, whenever the retrieved field (e.g. 'PR_INITIALS') is empty, the expression Row(x) contains a binary error code that I cannot deal with. Any Ideas as to what to put in the function HandleEmpty, so that HandleEmpty(Row(x)) returns a string? ......code snippet..................... ... Rows = Table.GetRows(CHUNKSIZE) If Not IsEmpty(Rows) Then For i = LBound(Rows) To UBound(Rows) Row = Rows(i) Debug.Print (HandleEmpty(Row(0)) & vbTab & HandleEmpty(Row(1)) & vbTab & HandleEmpty(Row(2)) & vbTab & HandleEmpty(Row(3)) & vbTab & HandleEmpty(Row(4))) 
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| no subject e mails, how do I deal with them? | T5 | Outlook - General Queries | 8 | November 25th 06 06:45 PM |
| How do I get a propertyvalue from a mapitable | [email protected] | Outlook and VBA | 1 | October 4th 06 07:51 PM |
| Redemption - MapiTable : BusyStatus | Tadwick | Outlook and VBA | 4 | August 10th 06 07:36 PM |
| Help wanted Using redemption to see emails in CC,BCC and TO fields | bobdydd | Outlook and VBA | 1 | June 9th 06 11:11 PM |
| Redemption MAPITable | Dmitry Streblechenko | Add-ins for Outlook | 1 | January 12th 06 05:09 AM |
Threaded Mode