VBA Mailer overview

With the new Outlook version the ability to send emails from your Office applications is lost. VBA Mailer not only fills in the gap, but has added important new features:

• A wizard to easily set up the email processes for common scenarios in Excel and MS Access.
• Easy writing of HTML emails in the template editor.
• A transparent way of encoding the message body in VBA.

VBA Mailer has implemented its COM object model following its precursor with the objective of allowing easy automated migration of macros that currently use Outlook VBA.

Sending Email using VBA

After installing the software the following steps:

• Open the VBA document or Access database you want to use VBA Mailer with.
• Open the VBA Editor. You will see a small toolbar added: VBA Mailer.
• Open the Accounts dialog and enter the email account data.
• To Migrate from Outlook to VBA Mailer select the Migrate menu option.
• Test the migration by simply running the macro you always used to send mails
• To create a new email macro select the corresponding menu
• Complete the initially inserted code optionally using the template editor.
• run the macro to verify it works.