PhysiologyWeb Logo  Search
Share on Facebook Share on Twitter Share on LinkedIn Share on Pinterest Email Copy URL
PhysiologyWeb Loading...

Delphi Code - Search Microsoft Outlook Read Emails within a Date Range
Here is a simple Delphi procedure that searches for Microsoft Outlook emails within a defined date range. As written, the code checks for read emails received within the specified date range (i.e., these emails have already been read and marked as such). This simple code can be modified further to perform sophisticated Outlook email searches. The code works well whether or not Outlook is already open. However, please note that the code will not work if Outlook is closed, and your installed Outlook requires any form of authentication upon launching the program. The most relevant parts of the code are highlighted. Comments are included to explain the code. If you copy and paste the code into your program, be sure to change the form and procedure names to match your setup. For additional Outlook automation solutions, see Microsoft Outlook Automation with Delphi.
procedure TForm1.SearchMicrosoftOutlookReadEmailsWithinADateRange(Sender: TObject);
var
Count: Integer;
StartDate, EndDate: TDate;
OutlookFindString: String;
OutlookApplication, OutlookNameSpace, OutlookFolder, OutlookFolderEmailItems, OutlookMailItem: Variant;
begin
//be sure ComObj and Variants units are included in the "uses" clause

Count := 0;

StartDate := StrToDate('5/20/2022'); //start of date window
EndDate := StrToDate('5/31/2022'); //end date for search window
EndDate := EndDate + 1; //make the search inclusive for the specified window

OutlookFindString := '[ReceivedTime] >= "' + FormatDateTime('ddddd h:nn AMPM', StartDate) + '" and [ReceivedTime] < "' + FormatDateTime('ddddd h:nn AMPM', EndDate) + '"' + ' and [UnRead] = False';

OutlookApplication := Null;
OutlookNameSpace := Null;
OutlookFolder := Null;
OutlookFolderEmailItems := Null;
OutlookMailItem := Null;

try
//create Outlook OLE
OutlookApplication := CreateOleObject('Outlook.Application');
except
OutlookApplication := Null;
//add error/exception handling code as desired
end;

If VarIsNull(OutlookApplication) = False then
begin
try
OutlookNameSpace := OutlookApplication.GetNameSpace('MAPI');
OutlookNameSpace.Logon('', '', False, True);
OutlookFolder := OutlookNameSpace.GetDefaultFolder(6); //6 is Inbox
OutlookFolderEmailItems := OutlookFolder.Items;

OutlookFolderEmailItems.Sort('[ReceivedTime]', False); //True = descending; False = ascending

try
OutlookMailItem := Null;
OutlookMailItem := OutlookFolderEmailItems.Find(OutlookFindString);
//reference
//https://docs.microsoft.com/en-us/office/vba/api/outlook.items.find
repeat
If (VarIsNull(OutlookMailItem) = False) and (VarIsEmpty(OutlookMailItem) = False) then
begin
//add code to handle emails as desired.
//here we capture a summary of the emails found
//be sure a Memo1 VCL object exists
Count := Count + 1;
Memo1.Lines.Add(IntToStr(Count) + ' | Sent: ' + DateTimeToStr(OutlookMailItem.ReceivedTime) + ' | From: ' + OutlookMailItem.SenderName);
//referece
//https://docs.microsoft.com/en-us/office/vba/api/outlook.mailitem
end;
OutlookMailItem := Unassigned;
OutlookMailItem := OutlookFolderEmailItems.FindNext;
//reference
//https://docs.microsoft.com/en-us/office/vba/api/outlook.items.findnext
until (VarIsNull(OutlookMailItem) = True) or (VarIsEmpty(OutlookMailItem) = True);
except
//add error/exception handling code as desired
end;
finally
OutlookMailItem := Unassigned;
OutlookFolderEmailItems := Unassigned;
OutlookFolder := Unassigned;
OutlookNameSpace := Unassigned;
OutlookApplication := Unassigned;
end;
end;
end;






Posted: Saturday, July 16, 2022