Category Report

R

Rob F

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
 
M

Michael

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
 
R

Rob F

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

Thanks

Rob F
 
M

Michael

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:eek:ffice:eek:ffice#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...
 
Top