The table below shows the expiration dates of employee certificates:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Email[/TD]
[TD]Cert 1[/TD]
[TD]Cert 2[/TD]
[/TR]
[TR]
[TD]Adam[/TD]
[TD]adam@email.com[/TD]
[TD]30/7/2016[/TD]
[TD]30/8/2016[/TD]
[/TR]
[TR]
[TD]Henry[/TD]
[TD]henry@email.com[/TD]
[TD]29/6/2016[/TD]
[TD]13/7/2016[/TD]
[/TR]
[TR]
[TD]Karl[/TD]
[TD]karl@email.com[/TD]
[TD]13/7/2016[/TD]
[TD]14/9/2016[/TD]
[/TR]
</tbody>[/TABLE]
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.
[TABLE="width: 500"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Email[/TD]
[TD]Cert 1[/TD]
[TD]Cert 2[/TD]
[/TR]
[TR]
[TD]Adam[/TD]
[TD]adam@email.com[/TD]
[TD]30/7/2016[/TD]
[TD]30/8/2016[/TD]
[/TR]
[TR]
[TD]Henry[/TD]
[TD]henry@email.com[/TD]
[TD]29/6/2016[/TD]
[TD]13/7/2016[/TD]
[/TR]
[TR]
[TD]Karl[/TD]
[TD]karl@email.com[/TD]
[TD]13/7/2016[/TD]
[TD]14/9/2016[/TD]
[/TR]
</tbody>[/TABLE]
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.