OUTLOOK VBA TRICKS

How to Add Outlook Reference in Excel VBA

To automate Outlook based tasks from Excel you need to add Outlook Object Library (Microsoft Outlook XX.X Object Library) in Excel References. You can follow below steps to add Outlook reference in Excel VBA: 1. From the Menu Bar, click on Tools > References… 2. Select ‘Microsoft Outlook XX.X Object …

Read More
OUTLOOK VBA TRICKS

VBA Code to Send Outlook Emails

Sending bulk emails is very common activity, there are many office activities which needs a person to send bulk emails to a single or multiple recipients. You also may require to add attachments in the emails. Here is a VBA code that does this task, below VBA code reads recipients, …

Read More
OUTLOOK VBA TRICKS
3

VBA Code to Draft Outlook Emails

Have you ever felt the need of an Excel based VBA tool or code which can help you to draft Outlook emails in bulk by reading recipients and other details from Excel? Here is very simple solution to your problem, you can use below VBA code to draft emails in …

Read More
OUTLOOK VBA TRICKS

VBA Code to Read Outlook Emails

Reading emails from Outlook and capture them in Excel file is very common activity being performed in office environment. Doing this activity manually every time is quite boring and time consuming. Here is a VBA code that can help you in this, you can use this code to select an …

Read More