EXCEL 2011 Mac Macro

**romperstomper** · 02-25-2011, 12:08 PM

Have you actually tried it on a Mac? Other than replacing backslashes in filepaths with Application.Pathseparator you may not have a problem, especially as Office 2011 includes Outlook now.

**johnkubik** · 02-25-2011, 12:12 PM

Thank you for the response.

I have tried it. and it doesnt work

It creates the new workbook, but does not copy any of the cells (I used a watch and it doesnt even get the variables right). It also does not create a new email.

I am curious as to how to create the email in either Mac Mail, Entourage, or Outlook but there is no documentation I can find to do this. Do you know of a site that would list the calls for mailhandler?

**johnkubik** · 02-25-2011, 12:34 PM

Do you think it would be possible to automate using apple script? I looked at the automator functions roughly and am drawing a blank.

thanks though!

**romperstomper** · 02-25-2011, 12:37 PM

Again, not a clue. I don't use it for work, so have never needed to learn AS. Anyone using 2011 should have Outlook though, I think, so why not automate that?

**johnkubik** · 02-25-2011, 12:42 PM

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.

**Jim Gordon Mac MVP** · 04-09-2012, 10:14 AM

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.