View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
MacroAlan[_3_] MacroAlan[_3_] is offline
external usenet poster
 
Posts: 2
Default 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!