-
Pingback: ExcelSirJi | VBA TRICKS | VBA to Read Excel Data using Connection String
-
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 Library’ and click on ‘OK’ button
