Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
How can I get this to not stop when I receive an error and put a blank in
that range. I am receiving a run-time error [CDO - MAP_E_NOT_FOUND(8004010F]] ---------------------------------------------------------------------------- ------------------ For Each myAddressEntry In objSession.AddressLists.Item("Global Address List").AddressEntries If Len(myAddressEntry.fields(PR_ACCOUNT)) = 7 Then Range("Feeder!B" & i).Value = myAddressEntry.fields(PR_DISPLAY_NAME) If Len(myAddressEntry.fields(PR_SMTP)) = 0 Then Range("Feeder!A" & i).Value = "" Else Range("Feeder!A" & i).Value = myAddressEntry.fields(PR_SMTP) End If If Len(myAddressEntry.fields(PR_EMS_AB_HOME_MTA)) = 0 Then Range("Feeder!C" & i).Value = "" Else Range("Feeder!C" & i).Value = myAddressEntry.fields(PR_EMS_AB_HOME_MTA) End If i = i + 1 End If Next Thank you |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Error checking | Excel Discussion (Misc queries) | |||
#DIV/0! Error-Another Twist, assistance please? | Excel Worksheet Functions | |||
Error Checking | Excel Discussion (Misc queries) | |||
Error Checking | Excel Discussion (Misc queries) | |||
Error Checking | Excel Discussion (Misc queries) |