Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
custimized outlook today in outlook 2007 | Excel Discussion (Misc queries) | |||
excel open in outlook if outlook is running | Excel Discussion (Misc queries) | |||
Send to Outlook 2000 not Outlook Express | Excel Discussion (Misc queries) | |||
Outlook 2003 demo back to Outlook XP | Excel Discussion (Misc queries) | |||
Outlook vs Outlook Express | Excel Worksheet Functions |