En cours

Outlook Email Macro

We need an Outlook search filter or macro to search for messages and return them grouped by subject.

Summary:

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.

Detail:

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.

That's it.

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

Compétences : Visual Basic, Visual Basic pour les apps

Voir plus : email macro outlook, yet received, received yet, n equals, june month, call dave, outlook email macro, simply comments, outlook visual basic, outlook email, outlook add, outbox, macro, macro e, it helpdesk, helpdesk it, email searching, email process, answering emails, outlook retrieve, 504, please find attached folder, outlook add macro, retrieve email, change email

Concernant l'employeur :
( 1 commentaire ) Canberra, Australia

N° du projet : #1673506

Décerné à :

bharanisrihari

Hello, VBA expert here. Please check PM for details. Thanks!

250 $ AUD en 7 jours
(29 Commentaires)
5.7

6 freelance ont fait une offre moyenne de 192 $ pour ce travail

Rahul2012

Please check your PM.

250 $ AUD en 3 jours
(14 Commentaires)
5.1
devhead1962

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

200 $ AUD en 7 jours
(1 Commentaire)
4.0
johnsinit

Dear John! I am an experienced VB and VBA programmer and would be happy to work for you. Please, check PMB. Sincerely yours, John.

180 $ AUD en 5 jours
(7 Commentaires)
3.6
infiniumsol

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

200 $ AUD en 5 jours
(1 Commentaire)
2.2
spcinc

I can do it!

250 $ AUD en 5 jours
(0 Commentaires)
0.0
kovis

As an developer with 12 years of practice I can do the task quickly and efficiently.

170 $ AUD en 5 jours
(0 Commentaires)
0.0
vikrantsingh85

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.

100 $ AUD en 5 jours
(0 Commentaires)
0.0