Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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!
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
custimized outlook today in outlook 2007 Hal Excel Discussion (Misc queries) 2 June 20th 07 12:59 AM
excel open in outlook if outlook is running kirk Excel Discussion (Misc queries) 0 May 24th 06 06:42 PM
Send to Outlook 2000 not Outlook Express Jimbo Excel Discussion (Misc queries) 2 January 4th 05 08:19 PM
Outlook 2003 demo back to Outlook XP Pete Carr Excel Discussion (Misc queries) 1 December 22nd 04 08:04 AM
Outlook vs Outlook Express Stuart Excel Worksheet Functions 1 December 13th 04 08:54 PM


All times are GMT +1. The time now is 07:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"