Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Counting number of e-mail arrived with specific subject for a day, from Excel
Hi,
I need help to code VBA in Excel to: Count the number of e-mail with subject beginning with "Virus Alert: Detected Not Removed" on a specified date, the date is the value of cell in the date column. Sample data: A B 1 Date Alert Mails 2 03 Aug 2009 3 3 04 Aug 2009 4 05 Aug 2009 At the worksheet activate event I want to let the code check if any there is empty cell in the "Alert Mails" column for which the corresponding date value in "date" column is today or older. If there is (in the sample above, the cell B3 is empty and meets the condition that it corresponds to today or older), go to Outlook folder "Virus Alerts" and count the number of e-mails with the subject beginning with "Virus Alert: Detected Not Removed" and the send date of the e-mail = value of A3. The result of the count should then be entered into B3. It should then continue to check for other cells in "Alert Mails" column and do the counting of e-mails until corresponding cell in column date is greater than today. Any help is very much appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
send e-mail from Excel, copy and paste at specific place in e-mail | Excel Programming | |||
Counting Specific Number of Days across Multiple Months | Excel Programming | |||
Counting Specific Number of Days across Multiple Months | Links and Linking in Excel | |||
How I auto send e-mail from excel with predefined subject and tex | Excel Programming | |||
Counting a specific number only if an adjacent cell has something | Excel Discussion (Misc queries) |