How to send Automated Email when specific cell value reached due date

[grlinks]

Hi Every one

I<gs id="2318bee7-d212-463e-b967-03ea1e18157b" ginger_software_uiphraseguid="a8a610bd-27c2-4fcc-8df6-7c0cb0c62bc2" class="GINGER_SOFTWARE_mark">'ve excel</gs> sheet (invoice)<gs id="4e1ac729-14e2-4409-a9a4-28598ad216f9" ginger_software_uiphraseguid="a8a610bd-27c2-4fcc-8df6-7c0cb0c62bc2" class="GINGER_SOFTWARE_mark"> ,</gs> <gs id="fc9fb2f7-a2bf-47bd-b27c-d5564c945910" ginger_software_uiphraseguid="a8a610bd-27c2-4fcc-8df6-7c0cb0c62bc2" class="GINGER_SOFTWARE_mark">i</gs> am updating client invoice and bill status regularly<gs id="97ec672d-adc4-4052-87f1-6a6a7c9433f5" ginger_software_uiphraseguid="a8a610bd-27c2-4fcc-8df6-7c0cb0c62bc2" class="GINGER_SOFTWARE_mark"> ,</gs> <gs id="8136ca43-2b7f-4b75-8aec-7bf798b898f6" ginger_software_uiphraseguid="a8a610bd-27c2-4fcc-8df6-7c0cb0c62bc2" class="GINGER_SOFTWARE_mark">i</gs> need to send <gs id="617b04ca-f6ab-4c1e-82c7-cdcba5341df5" ginger_software_uiphraseguid="a8a610bd-27c2-4fcc-8df6-7c0cb0c62bc2" class="GINGER_SOFTWARE_mark">remainder</gs> email to my client before bill reaches credit <gs id="e78c7cb9-e2b9-4c39-bcca-b8cf9536abe5" ginger_software_uiphraseguid="a8a610bd-27c2-4fcc-8df6-7c0cb0c62bc2" class="GINGER_SOFTWARE_mark">date</gs> (before 7 days) (only Pending bills), <gs id="94b91a09-f4b0-4403-b0b1-1eefd0d573de" ginger_software_uiphraseguid="a8a610bd-27c2-4fcc-8df6-7c0cb0c62bc2" class="GINGER_SOFTWARE_mark">i</gs> am manually sending the email so far to my clients,

<gs id="173b7b97-f113-4870-ac49-460885df8679" ginger_software_uiphraseguid="fc938b6a-14c7-4bf6-9bda-7b5d0f3f1a45" class="GINGER_SOFTWARE_mark">is</gs> there any option that automated email can send from excel before due reaches (7days before and 3 days before)<gs id="9a58f9ab-b164-43db-bcf2-8f868ad88ab8" ginger_software_uiphraseguid="fc938b6a-14c7-4bf6-9bda-7b5d0f3f1a45" class="GINGER_SOFTWARE_mark"> ,</gs> could <gs id="1d54c887-b55a-42f6-8998-07b531d960e8" ginger_software_uiphraseguid="fc938b6a-14c7-4bf6-9bda-7b5d0f3f1a45" class="GINGER_SOFTWARE_mark">any one</gs> help me


Email Format

Excel sheet Sample

<tbody>
</tbody>

 

[arthurbr]

This is a well-known problem already asked on this forum and others.
Mail from Excel and make/mail PDF files (Windows) covers most of the solutions

 

[Joe4]

Cross-posted here: How to send Automated Email when specific cell value reached due date

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule #13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.