Forum Discussion

JPC1804's avatar
JPC1804
Copper Contributor
Oct 19, 2021

Sending email from within Excel for Mac

Hello,

 

I use Microsoft Excel for Mac 16.50. I am trying to share an Excel workbook via my Outlook 365 email but Apple Mail opens by default. I don't see where I can change the default email client, so that Excel automatically opens Outlook 365. Any suggestions?

 

Thank you.

 

Jonathan

Excel on Mac
office 365

2 Replies

  • NikolinoDE's avatar
    NikolinoDE
    Gold Contributor
    Oct 19, 2021

    JPC1804 

    My knowledge is very limited when it comes to Mac, but I can only recommend this site.

    I was able to use and expand some solutions from there.

     

    Send Mail from Mac Excel with Mac Outlook

    Test the code in the workbooks

    3 workbooks with code examples in the zip file for testing.

    1. MacOutlookWithExcel.xlsm to create a mail with the ActiveSheet, Selection, WorkBook, only text, row data
    2. MacOutlookWithExcelPDF.xlsm to create a mail with the ActiveSheet, Range or WorkBook as PDF
    3, MacOutlookWithExcelHTMLBody.xlsm to create a mail with the ActiveSheet/Selection in the body
     

    The third-party products that this article discusses are manufactured by companies that are independent of me. I makes no warranty, implied or otherwise, about the performance or reliability of these products.

     

    I would be happy to know if I could help.

     

    NikolinoDE

     

    Was the answer useful? Mark them as helpful!

    This will help all forum participants.

Resources