The table below shows the expiration dates of employee certificates:
<tbody>
</tbody>
I would like to run a macro that will then email all the certificates that are set to expire in the upcoming 30 days. Later I would like to have a button the triggers the macro.
Added info. I an running Microsoft Excel on a Mac and would like to you the Apple Mail app to send the emails.
Thank you.
Name | Cert 1 | Cert 2 | |
Adam | adam@email.com | 30/7/2016 | 30/8/2016 |
Henry | henry@email.com | 29/6/2016 | 13/7/2016 |
Karl | karl@email.com | 13/7/2016 | 14/9/2016 |
<tbody>
</tbody>
I would like to run a macro that will then email all the certificates that are set to expire in the upcoming 30 days. Later I would like to have a button the triggers the macro.
Added info. I an running Microsoft Excel on a Mac and would like to you the Apple Mail app to send the emails.
Thank you.