Outlook Banter

Outlook Banter (http://www.outlookbanter.com/)
-   Outlook and VBA (http://www.outlookbanter.com/outlook-vba/)
-   -   Sum up overtime hours for my sent mails over one year (http://www.outlookbanter.com/outlook-vba/7551-sum-up-overtime-hours-my.html)

Qiubang Li March 4th 06 01:09 AM

Sum up overtime hours for my sent mails over one year
 
Hi Everyone,

I have some experience in vba programming but a newbie in outlook
programming. Can anyone help me to write a code in outlook to calculate how
many hours I have worked for my boss for the past one year. My working hours
are 9:00AM - 5:00PM. Everyday I sent an daily progress update to my boss.
Sometimes it's at 5:30PM or 6:00PM. It means I have worked half an hour or 1
hour overtime at that particular day. The whole idea is to go to the sent
folder, check all those mails sent to my boss, and sum up all those hours
with mails sent after 5:00PM. Can anyone give me some idea how to do it?
Many thanks.

--
Q Li



Michael Bauer March 6th 06 09:01 AM

Sum up overtime hours for my sent mails over one year
 
Am Sat, 4 Mar 2006 11:09:35 +1100 schrieb Qiubang Li:

Here is a sample how to restrict a folderīs content on a specified date
range:
http://www.outlookcode.com/d/finddate.htm

You could add the subject to the filter so that the result contains only
those mails sent to your boss (with a specified subject) in a year.

Then loop through that result and check each itemīs SentOn property: If it
contains a "pm" and Hour(YourItem.SentOn) 5 then itīs a match.

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
-- www.vbOffice.net --


Hi Everyone,

I have some experience in vba programming but a newbie in outlook
programming. Can anyone help me to write a code in outlook to calculate

how
many hours I have worked for my boss for the past one year. My working

hours
are 9:00AM - 5:00PM. Everyday I sent an daily progress update to my boss.
Sometimes it's at 5:30PM or 6:00PM. It means I have worked half an hour or

1
hour overtime at that particular day. The whole idea is to go to the sent
folder, check all those mails sent to my boss, and sum up all those hours
with mails sent after 5:00PM. Can anyone give me some idea how to do it?
Many thanks.

--
Q Li



All times are GMT +1. The time now is 09:13 AM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 2.4.0
Copyright Đ2004-2006 OutlookBanter.com