ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Error Checking Assistance (https://www.excelbanter.com/excel-programming/310342-error-checking-assistance.html)

SyrU

Error Checking Assistance
 
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




All times are GMT +1. The time now is 05:08 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com