ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Get Outlook UserProperties (https://www.excelbanter.com/excel-programming/291795-get-outlook-userproperties.html)

MacroAlan[_3_]

Get Outlook UserProperties
 
I have this piece of code that I stole from Helen Federman's site:



'The next line illustrates the syntax for referencing
'a custom Outlook field

If itm.UserProperties("Horizons7") < "" Then
rnG.Value = itm.UserProperties("Horizons7")
End If

If itm.UserProperties("Wetlands") < "" Then rnG.Value =
itm.UserProperties("Wetlands")
End If

and I figured out what I needed to start retrieving items from Outlook.
My problem is that it is only pulling the first

itm.UserProperties

and does not write anything for the others.

Can I get a list of properties and the name that Excel/Outlook uses for
them?

*** It is pulling the list of 4800 contacts from the Public Folder in
about 20 minutes!

MacroAlan

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!


All times are GMT +1. The time now is 03:48 AM.

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