Đã hoàn thành

Outlook Email Macro

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.

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

Kĩ năng: Visual Basic, Visual Basic cho Ứng dụng

Xem nhiều hơn: email macro outlook, not yet received, not received yet, n equals, june is the month for, for the month of june, 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

Về Bên Thuê:
( 1 Nhận xét ) Canberra, Australia

ID dự án: #1673506

Được trao cho:


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

$250 AUD trong 7 ngày
(29 Đánh Giá)

6 freelancer đang chào giá trung bình $192 cho công việc này


Please check your PM.

$250 AUD trong 3 ngày
(14 Nhận xét)

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 trong 7 ngày
(1 Nhận xét)

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 trong 5 ngày
(7 Nhận xét)

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 Thêm

$200 AUD trong 5 ngày
(1 Nhận xét)

I can do it!

$250 AUD trong 5 ngày
(0 Nhận xét)

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

$170 AUD trong 5 ngày
(0 Nhận xét)

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 trong 5 ngày
(0 Nhận xét)