Migrating Outlook email macros to VBA Mailer

When switching to the new Outlook, VBA projects which until now you used Outlook VBA for emailing run into An error has occurred: Object creation not possible through ActiveX component. VBA Mailer has the Migrate from Outlook feature to keep your email automation running.

Depending on the whether you start with early or late binding the only code change that occurs is the replacement of the word Outlook by VBAMailer:


Dim appOL As VBAMailer.Application
Set appOL = New VBAMailer.Application
'or
Set obj = CreateObject("VBAMailer.Application")

What it does

Migrate from Outlook makes minimal changes to your VBA project

Removes reference to Outlook (when present).
Adds reference to the VBA Mailer COM library as a replacement.
Changes the line that creates the Outlook Application object by one creating a similar VBA Mailer Application object.

Where? The Migrate from Outlook feature is available from the VBA Mailer menu - it is visible only when Outlook actually is used in the project.

Migration report

When developing VBA Mailer Object Model, we have tried to stick as close as possible to the Outlook original so that users can continue using their current Outlook VBA based macros.

On completion, the migration process delivers a migration report. The report is located in the same folder as the office document (excel file, access db) being migrated as [office document name]_VBA_Mailer_migration.html. It tells which procedures have changed, procedures that require attention (warnings) and a list of remarks, primarily concerning unsupported Members of Outlook classes, e.g. MailItem.DeferredDeliveryTime: Not supported