Sue, I use exactly that right now, the problem is, I have several folders
underneath my mailbox root and underneath default folders like inbox, I take
one user at a time and have to iterate though all the folders and items in
them to find if the user+item+date matches, this serves my purpose but is
deadly slow when the number of items are many(some 5000), I was hoping if
there is something like a SQL query which is more efficient than this
method. See the code below
MySearchCriteria = "[Received] > '" & MyDateStart & "' and [Received] < '" &
MyDateEnd & "'"
Set MyResultItems = AllInboxItems.Restrict(MySearchCriteria)
MyResultItems.Sort ("[From]")
This however doesn't give me "group by"
-Am
"Sue Mosher [MVP-Outlook]" <suemvp@outlookcode.com> wrote in message
news:%23petdKwyIHA.3384@TK2MSFTNGP03.phx.gbl...
You can use the Items.Restrict method to filter by date range -- see
http://www.outlookcode.com/article.aspx?id=30 -- and add criteria for the
sender. The resulting Items collection will have a Count property.
"Amiable" <achaudhary311@hotmail.com> wrote in message
news:eZASzpuyIHA.2184@TK2MSFTNGP02.phx.gbl...
> Hi,
>
> I want to find out the number of emails sent by a particular user between
> specific dates and then find sum group by user name.
> Can anyone help me?
>
> A
>
>