automation

A pattern for creating sustainable routine reports in Excel.

Many organisations have evolved processes that require colleagues to email information to one another, or receive information by email from another organisation. In this case, you may want to automatically perform actions such as saving an email and its attachments to a folder when received if it meets certain criteria. Microsoft Outlook is ubiquituous in NHS organisations, and it is possible to automate Outlook processes using VBA.