Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Fetching emails for a specific date in c# using Exchange Web Services

I am able to fetch emails from a mailbox based on a subject. I am not sure what the format for fetching emails based on the received date?

           string message = string.Empty;
            Item item = Item.Bind(exService, messageID, PropertySet.FirstClassProperties);

            if (item is EmailMessage)
            {
                EmailMessage em = (EmailMessage)item;

                string strMsg = string.Empty;
                //strMsg = strMsg + item.Id.ToString();
                //strMsg = strMsg + item.DateTimeReceived;
                strMsg = strMsg + "*********************** New Fiscal Email received on " + item.DateTimeReceived  +" ************************************" + Environment.NewLine;

                if (em.Body.Text.Contains("BRANDON"))
                {
                    strMsg = strMsg + em.Body.Text.ToString();
                }
                strMsg = strMsg + "*********************** End of Email Body ************************************" + Environment.NewLine;
                message = strMsg;

            }
like image 627
acadia Avatar asked Jun 11 '12 12:06

acadia


2 Answers

I think the way SilverNinja told you is the right way. You should search the items like this:

DateTime searchdate = new DateTime (2012,7,6) //Year, month, day
SearchFilter greaterthanfilter = new SearchFilter.IsGreaterThanOrEqualTo(ItemSchema.DateTimeReceived, searchdate );
SearchFilter lessthanfilter = new SearchFilter.IsLessThan(ItemSchema.DateTimeReceived, searchdate.AddDays(1));
SearchFilter filter = new SearchFilter.SearchFilterCollection(LogicalOperator.And, greaterthanfilter, lessthanfilter);
Folder folder = Folder.Bind(this.m_Service, WellKnownFolderName.MsgFolderRoot); //Or the folder you want to search in
FindItemsResults<Item> results = folder.FindItems(filter, new ItemView(1000));

"results.Items" will return the first 1000 items which are recivied at the day you are looking for.

like image 106
Jürgen Hoffmann Avatar answered Oct 06 '22 01:10

Jürgen Hoffmann


Take a look at SearchFilter examples. You just need a filtering condition on ItemSchema.DateTimeReceived

like image 40
SliverNinja - MSFT Avatar answered Oct 06 '22 00:10

SliverNinja - MSFT