EXCEL 2011 Mac Macro

You are right... the problem is finding the mailhandler function for it. In windows it is

    Set OutApp = CreateObject("Outlook.Application")
    Set OutMail = OutApp.CreateItem(0)

Mac outlook/mail does not have an object that I can find.

To send a workbook as an email attachment using the default email application on the Mac you can use the following:

        If Application.OperatingSystem Like "*Mac*" Then
                With ActiveWorkbook
                    .SendMail Recipients:=MyRecipients, Subject:="Travel Request Authorization was approved " & Format(Date, "M/DD/YY")
                End With
        End If

At the moment, you can only have a single email recipient in the To field (this bug has been reported to Microsoft). In the example above MyRecipients would be an email address as text. You could also use "someone@someplace.com"with quotation marks in place of MyRecipients. Although the Subject command is valid and allowed, the subject will not be populated. I'm hoping this gets fixed in SP2, but I'm not holding my breath.