Скачать или смотреть AEU8: Cataloguing and searching emails with Access (Alessandro Grimaldi)

In this month's session, Alessandro Grimaldi demonstrated an Access application which communicates with Outlook to catalogue incoming emails. This was originally created for the European Central Bank, but the ideas can be adapted for any business or for personal use

A rather sophisticated “filter builder” is implemented, to create flexible and reusable queries to select emails matching specific criteria.

URL https://alessandrogrimaldi.com

TIMES:
0:00 Intro by Colin Riddington
1:56 Topic outline by Alessandro Grimaldi
3:49 Example app with 3 main features
4:13 a) Business Case Manager - originally designed for use by European Central Bank
6:23 b) Mail Manager - assign flag by colour category
10:27 c) Search Manager - powerful and wide ranging search with filters by by date range, time frame, field, operator, value etc. Up to 8 search conditions allowed. SQL for search available
14:20 Search example 1 with multiple filters to Outlook search folder
18:41 Search example 2 with different criteria to another Outlook search folder
20:15 Search folder manager
22:05 Use of 'Daemon' running in background which monitors the Outlook inbox and adds new unclassified emails to existing search folders
23:27 Admin Panel to manage vartious settings
24:12 PowerPoint presentation done for ECB staff explaining the application features for end users
30:13 Neil S - question on managing Outlook search folders dynamically in Access (DASL)
35:11 John H - question : how complex was writing code linked to Outlook namespaces?
39:40 Ant C - question : use with Exchange? Yes
43:19 Colin R - question : does performance suffer if cataloguing a large number of emails? No - as being run in the background using Daemon
44:30 Pat H - question : asked for clarification on working with Outlook search folders
48:24 Pat H - question : how to categorize emails in Outlook? Wider discussion . . .
56:00 Colin R - concluding remarks
57:44 Outline of next month's presentation: George Hepworth - Power Apps for Access developers