Send email via excel

[JIMBOB77]

Hi
I am looking for code to allow me to send and email using Outlook based on data in an excel spreadsheet.
NOTE - I am using Excel for MAC (I Believe That This Complicates Things).

Basically...
Cell A1 Will Contain The Email Address
Cell B1 Will Contain The Location Of A File Which Needs Adding As An Attachment.

Within The Code I Also Need A Method To Add...
- Email Subject
- Email Body

Thanks

 

[yky]

You may find something here:

https://www.rondebruin.nl/mac_articles.htm