Ahh, you're using a Mac 🙁  Can't use this method to send email on a Mac I'm afraid.  Mac's do not support this.

I do not have a Mac nor have I ever done any development on one.

I can only point you to Ron de Bruin's code

https://www.rondebruin.nl/mac/macmail/macoutlook2016.htm

and see if you can incorporate that.  Unfortunately as I do not possess a Mac I can't test this code for you either.

Sorry.

Phil

Phil,

That website was very helpful - much appreciated!  So I now can email my document from excel with Ron de Bruin's code, which I have attached.  The only thing I can't do is email the various dropdown options.  Do you know how I might be able to incorporate the dropdown portion of your macro into Ron's code?

Hi Rob,

As I don't have a Mac there's no way for me to integrate my code with Ron's and test that it works.

You can try contacting Ron and seeing if he can help out.

regards

Phil

Hi Philip can you send me a copy of the first workbook.  for some strange reason I'm not able to open the file that is attached.  Thanks.  I'm trying to do the same thing.