Excel & Outlook for Mac - Macro? I was initially trying to create a macro in outlook. But outlook for mac doesn't support macros, so here we are back in excel, trying to integrate with Outlook. Here are instructions on exporting your contact list in Outlook 2011 for Mac to an Excel spreadsheet. That way you can send them to a friend, or sort them, or do a variety of other things. Part 1: Export from Outlook for Mac. Open Outlook for Mac and click on Contacts. From the File menu, choose Export. Get an Office Store add-in for Word or Excel for Mac. On the Insert menu, select Add-ins.
Import Contacts From Excel To Outlook For Mac
. This update provides improvements and new functionality along with critical fixes. For more information about this update, please visit the. Applies to:Office 365 Home, Office 365 Personal, Office 365 University, Office 365 Business, Office 365 Business Premium, Office 365 Small Business Premium, Office 365 Midsize Business, Office 365 Enterprise E3, Office 365 Enterprise E4, Office 365 ProPlus, Office 365 Government G3, Office 365 Government G4, Office 365 Education A3, Office 365 Education A4, Office 365 ProPlus for Students, and Office 365 ProPlus A for Students.
I was initially trying to create a macro in outlook. But outlook for mac doesn't support macros, so here we are back in excel, trying to integrate with Outlook. I get about 25 'sales lead' emails daily, and i'm wanting the details to automatically create contacts in my outlook.
I can do the manual part of the task - copy and paste to an excel sheet, and it copies; Name: abc xyz Email: Phone: 0400 000 000 / / i know the very basics of VBA, and have googled, however i'm having connectivity troubles with outlook it seems to be erroring; Dim objOutlook As New Outlook.Application Thanks.