April 28th 07, 03:32 PM
posted to microsoft.public.outlook.calendaring
|
|
|
Sum up all 'durations' in a Find result display
Excellent. Many thanks.
"Sue Mosher [MVP-Outlook]" wrote:
You would need to write your own VBA macro to iterate all the items in the folder that meet your search criteria and generate a running total. VBA basics start at http://www.outlookcode.com/d/vbabasics.htm. If you get stuck, there is a newsgroup specifically for general Outlook programming issues "down the hall" at microsoft.public.outlook.program_vba or, via web interface, at http://www.microsoft.com/office/comm....program_v ba
--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx
"itambrose" wrote in message ...
So no function for this at all in Outlook? Not even creating your own
rules/macros/functions? Hard to believe it's not there....
"Sue Mosher [MVP-Outlook]" wrote:
Copy and paste the display to Excel and do the math there.
"itambrose" wrote in message ...
I'm wanting to add my work annual leave to Outlook and auto sum, so I know
how much holiday I've up so far. I'm currently adding it in as an Appointment
called A/L, then I search for text A/L. My results search has the following
fields:
*Subject (A/L)
*Start & End (date and time) (usually start at 8:30 and ends to achieve the
right number of hours
*Duration (in hours)
I'm after a way to sum up the all 'durations' in this Find result.
Or just an easier way to record, search for a sum up annual leave in
Outlook...
Any ideas?
I'm using Outlook 2000 and 2003
|