Send e-mail using mail client (Mozilla Thunderbird) based on date in excel cell

[vladimirzrnic]

Morning

I'm after solution for sending a e-mail using installed mail client Mozilla Thunderbird based on date in excel cell.

Excel file is very simple and contain 4 column.

Column 1 Column 2 Column 3 Column 4
Client name Client number 03.03.2016 13.03.2016

When date in column 3 match current data excel should send e-mail to two address with subject: "Warning! The validity of the document expires in 10 days"
When date in column 4 match current data excel should send e-mail to two address with subject: "Warning! The validity of the document expires today"
I don't need body text.

Excel file will be opened every morning.

BR

 

[Andrew Poulsom]

For sending an Email when a cell reaches a certain value see:

Send a mail when a cell reaches a certain value

For sending using Mozilla Thunderbird as the mail client see:

Carriage Returns stripped from Command Line generated e-mail • mozillaZine Forums