Category Report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

This is something I would love to be able to do. Can anyone help with some
VBA to do it?

I use categories a lot in Outlook 2003 and have emails, tasks, and notes all
under the same category.

What I'd like to do is print a summary report for a category (or
categories), which listed all items under that category (e.g. subject, date,
item type) regardless of their item type.

Can this be done?

Rob F
 
Hi,

My idea is to create a new view for the current explorer depend on your
requirements. Than you can print it.

or

Via VBA makro reading the outlook contents depend on the category
reqirements and export into an Excel sheet as a report.

Hope this will help!

Michael
 
Thanks, Michael. Can anyone help with the actual VBA code, as I haven't got a
clue how to do this?!

Thanks

Rob F
 
Hi Eric

Looks like a good sample! I will also test it it on weekend!
Thanks
Michael

Eric Legault said:
You can use the AdvancedSearch method with a DASL restriction on the
Categories property:

urn:schemas-microsoft-com:office:office#Keywords = 'MyCategory'

AdvancedSearch Method [Outlook 2003 VBA Language Reference]:
http://msdn.microsoft.com/library/en-us/vbaol11/html/olmthAdvancedSearch_HV03089488.asp?frame=true

The above link has some good code examples. Then loop through the
returned
results to build your report.

--
Eric Legault (Outlook MVP, MCDBA, old school WOSA MCSD, B.A.)
Try Picture Attachments Wizard for Outlook:
http://www.collaborativeinnovations.ca
Blog: http://blogs.officezealot.com/legault/


Rob F said:
Thanks, Michael. Can anyone help with the actual VBA code, as I haven't
got a
clue how to do this?!

Thanks

Rob F
Click to expand...
Click to expand...
 
Back
Top