Macro list of company names in tasks field (outlook 2010)
Posted on 2014-10-22
Tasks in general have a field labeled "Company".
Provide a list with two sections. First section with a header of "´Projects with non-completed tasks" this section composed of companies listed under point #1 below followed by a header for next section of "Project with all tasks all marked complete" followed by the information listed in point #2 below.
1. Lists all Companies (only once per company, and sorted in alphabetical order) which contain at least one task with a flag status criteria "does not" equal to "completed".
2. List all Companies (only once per company, and sorted in alphabetical order) which contain all taskss with a flag status criteria "equal to" "completed".