Email Integration Master Class

A master class from the Financial Analysis VBA Certificate Master Class series

An Extension of Australia’s premier Excel VBA course for finance professionals

This two-day master class focuses on issues around email integration in Excel-based VBA applications. It covers integration with Outlook email, but also web-based email applications, such as Gmail. It also demonstrates proven techniques for composing email content, handling signatures and attachments.

Course Content

Downloadable master class brochure with detailed course outline in PDF format (97kb).

Modes of Study

  • In class mode: 16 hours over two days.
  • Public offerings starting in Sydney in 2016.
  • Private offerings also available.

Key Outcomes

  • Gain advanced skills in key subject areas, such as working with other Office applications;
  • Advantages and disadvantages of early and late binding to mail objects;
  • Working with specific and generic mail platforms;
  • Managing mailing address lists, including rules for cc and bcc;
  • Composing mail content, including managing substitution terms;
  • Managing emailed responses, mail store;
  • Handling email signatures;
  • Up to 16 hours of continuing professional education.

Each Master Class Delivers

  • Core knowledge for the specialised subject area;
  • Re-usable examples demonstrating proven methodologies;
  • Guidance on how to avoid real-world issues and problems; and
  • Advanced techniques to build powerful and robust solutions without needless complexity.

Who Benefits

Those who have previously completed the Financial Analysis VBA Certificate or Financial Analysis Systems Certificate looking for support & guidance to extend their knowledge in building robust reports that will significantly reduce effort at key points in the reporting cycle.

Benefits for the Employer

  • A reduction in the effort required by staff to expand into key advanced topics;
  • Access to proven and effective strategies for advanced application and code building; and
  • A development path for key staff involved in creation of automated distribution and workflow solutions.

Detailed Course Outline & Other Information

Downloadable master class brochure with detailed course outline in PDF format (97kb).

Downloadable course brochure with detailed course outline in PDF format (93kb).

Find a suitable course by reviewing the article Which Course Would Best Suit me?

Find an offering in the Course Calendar.