Hi there,
I'm struggling to create a workable macro to send an email reminder when a due date arrives. The headings below cover everything in the spreadsheet. The first part of the code is to email a colleague when the "Date report due" with the information from No./Description and Date of the incident. The next email reminder would be for the "Rec due date" with No./description/recommendation. A 3rd reminder email for the "Extension 30 day" with the same information as the 2nd reminder. I also need it to be able to recognise that if the "Date report completed" is filled with a date, then to only send a reminder if there is no date under "Date measure completed". If both these dates are filled then no reminder is sent. I realise that a database would probably be the best option for this, but have no idea where to start with that either without access to something to Access, which I don't have.
[TABLE="width: 987"]
<tbody>[TR]
[TD="class: xl66, width: 38"]No.[/TD]
[TD="class: xl67, width: 197"]Description of incident [/TD]
[TD="class: xl67, width: 76"]Date of incident [/TD]
[TD="class: xl73, width: 38"]Who[/TD]
[TD="class: xl70, width: 76"]Date report due[/TD]
[TD="class: xl67, width: 76"]Date report completed[/TD]
[TD="class: xl68, width: 82"]Notes[/TD]
[TD="class: xl69, width: 170"]Recommendations[/TD]
[TD="class: xl71, width: 76"]Rec due date[/TD]
[TD="class: xl70, width: 76"]Extension 30 day[/TD]
[TD="class: xl72, width: 82"]Date measure completed[/TD]
[/TR]
</tbody>[/TABLE]
I'm struggling to create a workable macro to send an email reminder when a due date arrives. The headings below cover everything in the spreadsheet. The first part of the code is to email a colleague when the "Date report due" with the information from No./Description and Date of the incident. The next email reminder would be for the "Rec due date" with No./description/recommendation. A 3rd reminder email for the "Extension 30 day" with the same information as the 2nd reminder. I also need it to be able to recognise that if the "Date report completed" is filled with a date, then to only send a reminder if there is no date under "Date measure completed". If both these dates are filled then no reminder is sent. I realise that a database would probably be the best option for this, but have no idea where to start with that either without access to something to Access, which I don't have.
[TABLE="width: 987"]
<tbody>[TR]
[TD="class: xl66, width: 38"]No.[/TD]
[TD="class: xl67, width: 197"]Description of incident [/TD]
[TD="class: xl67, width: 76"]Date of incident [/TD]
[TD="class: xl73, width: 38"]Who[/TD]
[TD="class: xl70, width: 76"]Date report due[/TD]
[TD="class: xl67, width: 76"]Date report completed[/TD]
[TD="class: xl68, width: 82"]Notes[/TD]
[TD="class: xl69, width: 170"]Recommendations[/TD]
[TD="class: xl71, width: 76"]Rec due date[/TD]
[TD="class: xl70, width: 76"]Extension 30 day[/TD]
[TD="class: xl72, width: 82"]Date measure completed[/TD]
[/TR]
</tbody>[/TABLE]