 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Outlook / Calendaring / April 2007Sum up all 'durations' in a Find result display
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 Copy and paste the display to Excel and do the math there.  SignatureSue 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 > 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 [quoted text clipped - 9 lines] > Any ideas? > I'm using Outlook 2000 and 2003 So no function for this at all in Outlook? Not even creating your own rules/macros/functions? Hard to believe it's not there.... > Copy and paste the display to Excel and do the math there. > [quoted text clipped - 11 lines] > > Any ideas? > > I'm using Outlook 2000 and 2003 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/community/en-us/default.mspx?dg=microsoft.public .outlook.program_vba SignatureSue 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 > So no function for this at all in Outlook? Not even creating your own > rules/macros/functions? Hard to believe it's not there.... > >> Copy and paste the display to Excel and do the math there. >> >> > I'm wanting to add my work annual leave to Outlook and auto sum, so I know [quoted text clipped - 10 lines] >> > Any ideas? >> > I'm using Outlook 2000 and 2003 Excellent. Many thanks. > 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/community/en-us/default.mspx?dg=microsoft.public .outlook.program_vba > [quoted text clipped - 17 lines] > >> > Any ideas? > >> > I'm using Outlook 2000 and 2003
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.