Export text of Search Results to Excel

  • Thread starter Thread starter TOMB
  • Start date Start date
T

TOMB

I have Excel based VBA code to capture Calendar information and export to
excel.

Is there a way to capture the text of the results from the advance search
feature in Outlook to 'export' to Excel?

Simular to the info below:

From Subject Received Folder
Bob Jones Search Term A Fri 02/06/2009 9:35 AM Sent
Bob Jones Search Term A Fri 02/06/2009 10:45 AM Inbox
Mary Jane Search Term B Fri 02/04/2009 08:15 AM Sent
Mary Jane Search Term B Fri 02/06/2009 1:45 PM Inbox
Mary Jane Search Term B Fri 02/06/2009 2:15 PM Sent
John Doe Search Term C Fri 02/06/2009 10:45 AM Sent


Thanks in Advance
- - TB - -
 
After you call AdvancedSearch(...) (returns Search object), call
Search.Save, which returns MAPIFolder object. You can then loop through the
items in that folder (MAPIFolder.Items).

--
Dmitry Streblechenko (MVP)
http://www.dimastr.com/
OutlookSpy - Outlook, CDO
and MAPI Developer Tool
-
 
Back
Top