subject ---> creating an excel report based off Outlook public calendars...

[Normand]

Hello:
Pardon me for being new, maybe this is quite trivial
(hopefully)... I am trying to create a absentee db so to
speak using a calendar in the public area of Exchange. I
have created an extra page in the original form of a new
appointment form. It has a field called Absent_Reasons,
in a list box of the 4 common reasons why an employee
would be absent. I am realizing first that I can not
export out from the public folders area (unless I can and
just have turned a property on somewhere)... so I figured
maybe I can set up a method where I could once a quarter
or so copy the appointment info from the public area to a
private calendar area, then perform an export to MS
excel. But when I try to export, I can not find any field
called Absent_Reasons... how do I have outlook's export
function see/find this field? TIA and please feel free to
e-mail me a CC on your responses.
Sincerely, Normand

 

[Sue Mosher [MVP]]

Outlook doesn't support exporting custom fields. Quick and dirty method:

1. Put all the items from your form in one folder.
2. Use a table view to display all the data fields that you want to export to Excel.
3. Choose Edit | Select All.
4. Choose Edit | Copy.
5. Paste to Excel.

Otherwise, you'd have to write custom code or use a third-party application. See http://www.slipstick.com/dev/customimport.htm.

--
Sue Mosher, Outlook MVP
Outlook and Exchange solutions at http://www.slipstick.com
Author of
Microsoft Outlook Programming: Jumpstart
for Administrators, Power Users, and Developers
http://www.slipstick.com/books/jumpstart.htm