VBA code to send email on todays date with other cell values

[DroitBlade]

Hi there!

I am trying to find code to enable excel to send an automatic email to 2 recipients with certain cell information every 28 days from when the Quote Date is entered (column H). For example:

So, I'd need to send the automatic email but only if the "status" tab says "quoted". If it says "ordered" or "lost" in the Status tab, then no email will be sent

I'd need the project name, Quotation number, Contractor, Merchant, consultant and notes (in row N....just out of view!) to be included within the email.

Can anyone help me with this

Thanks in advance!

Neil