Hi,

I have never used VBA before but it seems to be the only way to automate emails with the information I have in my excel sheet.
I use outlook as my email application.

Here is what I have:

Sheet 1 named "Data"
- Row 1 is the headers of each column
- Column A is "Die Number", where I have part numbers and i have hundreds of rows of part numbers.
- I have conditional formatting that will only fill blank cells in orange (as reminder of upcoming due date) and red (due/past due).
- This conditional formatting spans cells H2:N999.

Sheet 3 name "Email List"
A list of email addresses I would like to sent reminder/warning too


What I require/need help on:

I want to send 1 email everyday with the click of a button that details what die number has an orange warning or red warning in each row.
(Example for orange - Die 12345 - Please check die for completion ETA.)
(Example for red - Die 12345 is due Today/Past Due, please follow asap.)


Thank you very much for the help in advance.