Macro working in windows machine but not working in MAC

Hi,

The below macro works fine in windows machine but when I shared it with my friend who has Mac, it is giving error hat"Pubic Function Send () not defined". We both are using Office365

Please note, This macro is for sending individual emails using Lotus Notes to multiple users.

Can you please advise where am i missing..?

Please Login or Register  to view this content.

This macro appears to heavily rely on Lotus Notes objects. You can see this with the following lines

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

I would double check to make sure that Lotus Notes is installed on the Mac and listed in Excel's references.

Hi smpita, Thnaks for your reply.. Yes it is for sending emails using Lotus Notes which is installed on the MAC machine.. can you please tell me how to check if it is listed in Excel's References..?

I... can't seem to find it. It appears to be in a different place in OSX Excel. The option is not in the described location on my Mac Excel 2016. Maybe your version is different and it can be found on your machine in the location described by one of these links.

https://msdn.microsoft.com/en-us/vba...rary-reference

https://answers.microsoft.com/en-us/...7-7e872b693ba9

OSX uses some sandboxing techniques that may also be getting in the way of communication between Excel and Lotus Notes.

https://msdn.microsoft.com/en-us/lib.../mt654019.aspx

Unlike other versions of Office apps that support VBA, Office 2016 for Mac apps are sandboxed.
Sandboxing restricts the apps from accessing resources outside the app container. This affects any add-ins or macros that involve file access or communication across processes.