We need an Outlook search filter or macro to search for messages and return them grouped by subject.
Basically we are looking for conversations (all emails with the same subject) in the last 3 months, where and message in the conversation is not yet complete. Further, we have added another user-defined field called "Group" to the folder. If a member of a Group, selects their Group, they see only conversations where their Group is flagged, or no Group is flagged yet.
The following describes a process to achieve the final result, ie to display message set "B" or "C" described below. The following process is for illustrative purposes only so any logic can be developed provided the desired outcome is achieved. Add in line comments to your logic in case we (or you) need to change it in 6 months.
The folder to search is "helpdesk - inbox". We have added to our help inbox, a user-defined editable field called "Group". We set this to a team or person when they are allocated the task of answering a helpdesk email. The search criteria is a term called "Group" though we will come back to this.
The messages to search for first are all those in the last 3 full months where the status is not ticked as complete complete. i.e. if today is 3rd June, start from not 3rd Apr, but 1st Apr. I'll call this message set "A".
Then we need to find all messages in the "helpdesk - inbox" folder **, limited by the same 3 month date range, regardless of status (i.e. completed or not), where the subject is the same as a subject in set "A". i.e. we want the entire last 3 months of conversations (same subjects) where any message in the conversation is not complete. I'll call this larger message set "B".
If "Group" in the search crireria is blank, display message set "B", grouped by subject, expanded, sorted by descending received date.
If "Group" in the search crireria is NOT blank, then search message set "B" and retain only the conversations (all messages with the same subject) where either
a) the "Group" field in ANY message in the conversation contains (not equals) the Group search term, OR
b) the "Group" field in ALL messages in the conversation is blank (i.e. not yet allocated to a team or person)".
We will call this message set "C".
Display message set "C", grouped by subject, expanded, sorted by descending received date.
If it is easier to retrieve all documents in the date range and then simply expand or collapse folders based on them meeting the display criteria above, this is acceptable.
Refer the attached document for a result set searching for "dave" with only conversations meeting the criteria, and a second result set with all converstaions in the time period where those meeting the display criteria and expanded and others collapsed.** . As stated either will do.
if not much more effort we would like Message Set "B" to include, not only the "Helpdesk - inbox", but also the current user's "inbox" and "outbox". Budget is tight so please advise in your quote if this is included or not. Thanks
6 freelance font une offre moyenne de $192 pour ce travail
Hello, I have a lot of Outlook experience. Do you have a particular minimum Outlook version in mind or do you need it to work in all versions? Please see PM for more info. Thanks
Dear John! I am an experienced VB and VBA programmer and would be happy to work for you. Please, check PMB. Sincerely yours, John.
I am an ex alumni (Tech Lead) of worlds leading automation software company. With over 4 years of experience in IT Automation industry, having automated over 350 complex business processes, i can do this job better Plus
I have already worked on such kind of a project before and i would just need to modify the macro i made before to customize it according to the client's need.