Outlook export "modified" and "Notes" Fields

G

Guest

unable to exporcant the outlook contact items "modified" and "notes" fields
to excell. I can obtain standard fields such as FULLNAME and my user defined
names
all in outlook 2002
here is an excerpt of my script

Dim OLF As Outlook.MAPIFolder
Set OLF = GetObject("", _
"Outlook.Application").GetNamespace("MAPI").Folders("Personal
Folders")
While i < 12
i = i + 1
With OLF.Items(i)
' this does not work
debug.print .Modified
end with
wend

it also does not work with
".notes"
but works with other contactitem fields

what am I doing wrong?
 
S

Sue Mosher [MVP-Outlook]

Please use the object browser (F2 in VBA) to look up the correct names for the properties you want to work with.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 
G

Guest

Thanks-you Michael.
I did take a look as you suggested and indeed the "notes" nor the "modified"
are not members of contact item. However I did find LastModificationTime and
this will work. Your answer is very much appreciated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top