![]() |
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