How Can I Add Outlook as a Reference in Excel VBA?

Question

I am trying to automate an email for an Excel spreadsheet. I am on a 2016 MacBook using version 16.72 of Excel. I have Outlook installed on my system and am logged in. When I try to run my script, I get an error of 'ActiveX can't create object'. When I look in my available references, Outlook is not an option. Is there any command I can run to get it added?

Answer 1

ActiveX controls are not allowed in Excel for Mac.

Answer 2

Hi Renee,

Microsoft Outlook on Mac does not support Microsoft Visual Basic for Applications directly. Because there is no VBA in Mac Outlook, there's no way to reference it in the Excel VB Editor.

If you can explain a bit more about your scenario, we can offer suggestions. You might be able to automate your scenario using Word's mail merge. Or, you might be able to use VBA to issue AppleScript commands that Outlook will comply with.

Answer 3

Hi Jim,

I am pulling information from two excel spreadsheets, total expenses per employee and emails from another worksheet. The email will be sent to each employee containing their total.

So would it be best to do this automation on a Windows system? Everyone in the accounting department uses Windows anyway, I am the only one on a Mac.

Thanks so much for the reply!

Answer 4

Hi

This page explains how to send mail programmatically from Office for Mac https://www.macexcel.com/examples/mailpdf/