Multiple reminders from excel to outlook

Melahabit

New Member
Joined
Apr 2, 2018
Messages
1
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]
 

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

Forum statistics

Threads
1,224,822
Messages
6,181,165
Members
453,021
Latest member
Justyna P

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top