Converting PC Macro to work on Macbook

[monkeymaster]

I have a macro written on my PC that automatically generates emails based on 4 cells (to:, cc:, subject;, and body). However, I am training an employee at work to use the macro, but they have a Macbook.

How can I get this macro to work on Macs? I have zero coding experience and managed to put this together with help from this board.

Sub Mail_Workbooks()

Dim OutApp As Object, OutMail As Object, WS As Worksheet, r As Long





Set OutApp = CreateObject("Outlook.Application")



Set WS = Sheets("MACRO")

On Error Resume Next



For r = 2 To WS.Cells(Rows.Count, "A").End(xlUp).Row



With OutApp.CreateItem(0)

.To = WS.Cells(r, "A").Value

.CC = WS.Cells(r, "B").Value

.Subject = WS.Cells(r, "C").Value

.Body = WS.Cells(r, "D").Value

.Display

End With

DoEvents

Next r



On Error GoTo 0

Set OutApp = Nothing



End Sub

 

[sijpie]

hi monkeymaster, please use code tags when you post code. That makes it easier to read. Click on the little VBA icon at the top of your post window, and paste the code there.

VBA on MacOS is somewhat different from VBA for Windows. Some items, like ActiveX controls can't be used. Writing files to the drive needs careful thought because MacOS only allows writing to the sandbox. And now you are wanting to convert Outlook VBA to MacOS. First question: Do your Mac users use Outlook, or native mail system? If they use the native mail system, then I don't think you can do it. You will have to use AppleScript, which I have no experience with.

Ron de Bruin does a lot of coding on both platforms, check his website for some information Excel Automation - Ron de Bruin

Also see what is new in Office for MacOS VBA, because it has better support for AppleScript. Office for Mac for Visual Basic for Applications (VBA)

But you will need to get your hands on a Mac to develop and test your code

 

[RoryA]

FYI, Ron has a mac specific site too: www.macexcel.com