Export Custom Forms in Public Folder to Excel
so can you tell me what these fields are named in outlook because
when
I add them to the code i get a debug error
It's the Notes field and the Categories field. The following doesn't
work.
Cells(i, 28).Value = .Notes
Cells(i, 29).Value = .Categories
Oh also i'm getting the debug error on the Contacts field too. These
are all the default outlook fields but they're not being recognized in
the code. I get this debug error "Run-time error '438': Object
doesn't
support this property or method.- Hide quoted text -
Also all my dates fields are being exported to Excel with 949998 and
when there is a date in, for example 9/30/2007, in excel it displays
as 39355.3333333333
|