[MIT Licence]

VBmail

Virtually Basic E-Mail Template

Acts as an e-mail template for Outlook where you can specify recipients (To, CC, BCC), subject line, and message body.

Example

Installation

Option 1:

  1. Download the provided macro-enabled workbook (VBmail.xlsm).

Option 2:

  1. Download the provided non-macro enabled workbook (VBmail_non-macro.xlsx).
  2. Download the source code (VMmail.cls).
  3. Open the workbook.
  4. Select "View" on the toolbar.
  5. Select "Macros" and "View Macros".
  6. Enter "VBmail" for Macro Name and select "Edit".
  7. Paste the source code into editor and click "Save".
  8. Save the workbook as a macro-enabled workbook (.xlsm).

Option 3:

  1. Download the source code (VBmail.cls).
  2. Create your own macro enabled workbook (.xlsm).
  3. Follow steps 3-7 from option 2. 

Requirements

[Macro Enabled Workbook]

[Configured Outlook Account]

Usage

If using the pre-loaded workbook, you can follow these steps:

  1. Open the workbook.
  2. Click the "Enable Content" security warning (if prompted).
  3. Replace the example content with your own (recipients, subject, message).
  4. Click the "Send" button. 

If you are manually installing the script, you can follow the steps below after saving your code:

  1. Select "View" from the toolbar.
  2. Select "Macros" and "View Macros".
  3. Select the "VBmail" macro and click "Run"