Microsoft Outlook 2019/2016. Level 2. Macros - course RUB 23,990. from Specialist, training, Date: November 28, 2023.

A true expert teacher, Microsoft Certified Trainer. Andrey Nikolaevich has more than 15 years of teaching experience. He is able to present the most complex material in an accessible manner. Its grateful graduates invariably note the friendliness towards students, the use of practical examples from life in the classroom and the desire to convey all their vast experience and deep knowledge.
Andrey Nikolaevich graduated with honors from the Moscow State Aviation Technological University (RGTU named after. TO. E. Tsiolkovsky). He worked as a research assistant at the Central Institute of Aviation Engine Engineering (CIAM) named after. P.I. Baranova. He has been teaching at Specialist since 1999. Specializes in providing training on Microsoft Access databases and programming in the Microsoft Office environment in VBA. In addition to teaching at the Center, he provides consulting services and participates in the development of applications for desktop databases and automation projects for Microsoft Office applications.
Author of popular training courses “Visual Basic for Application (VBA). Automation of work in Microsoft Excel", "Microsoft Access. Database development" and many others. The teacher has many publications in the popular computer magazine “Computer Press”.
Over the years of teaching at the center, Andrei Nikolaevich has successfully trained several thousand specialists. Among its graduates are employees of many large companies and organizations, including Coca-Cola, Bosco Sport, Dirol Cadbury, Michelin, Bosch-Siemens, Canon and many others.

Module 1. Basics of programming in Outlook using VBA (6 ac. h.)

-Programming features in Outlook
-Working in the Microsoft Visual Basic for Application editor
-Creation of standard modules, programming procedures and functions
-Creating custom VBA forms

Module 2. Programming Outlook objects (4 ac. h.)

-The Application object, its properties and methods
-Namespace object
-Folders collection and MAPIFolder object
-Items collection and Outlook item objects
-Working with folder elements (contacts, calendar items, etc.)
-Programming Outlook events

Module 3. Automation of work with mail messages (4 ac. h.)

-Creating an email message programmatically
-Programming work with elements of mail message folders
-Automation of work with attachments
-Practical work: Software processing of incoming messages

Module 4. Programming access to Outlook from other applications (2 ac. h.)

-Ability to program access to Outlook objects from other MS Office applications
-Creating a containerized application to automate Outlook in MS Excel
-Practical work: Creating a container application to automate Outlook in a Microsoft Excel project