macro to send from Excel a unique email with recipients defined in cells via Microsoft Outlook

[andreagiugio]

Hi all,

I am trying to send from Excel a unique email with recipients defined in cells from D6 to D50 via Microsoft Outlook.

Could you please anyone help me with the code?

I would like to have a button that automatically send this email. The email should be unique and the recipients should be multiples (each account email is present in cells from D6 to D50). In this case the last email is in D50, but it could be before D50 or after it, what should I do in this case?

Thanks a lot for your help!!