Excel 2013 auto sending of reminder e-mail

June 7, 2017 at 01:47:19
Specs: Windows 13
GOOD DAY,

NEED YOUR KIND ASSISTANCE TO THE FORMULA I MAY FORM TO SEND REMINDER E-MAIL TO MY CLIENTS IF ONE OF THE 3 COLUMNS CONTAINING DEPOSITS DUE DATE IS WITHIN 1DAY AND NOT YET BEING PAID.

THANK YOU


See More: Excel 2013 auto sending of reminder e-mail

Report •

#1
June 7, 2017 at 04:50:29
This cannot be achieved with a formula you will need a macro. The requirement is fairly straight forward but we need some more information to be able to produce this.

How is your workbook laid out? we need to know

1) which cell has the dates in it
2) which cell has the email addresses to which you want the email to be sent
3) what the email body and subject will be

Also please note writing it caps is considered shouting, please don't type in caps.


Report •

#2
June 8, 2017 at 06:33:28
re: "AND NOT YET BEING PAID."

How will the code know if the payment has been paid? Is there a cell that contains "Paid" or something like that?

re: "IF ONE OF THE 3 COLUMNS CONTAINING DEPOSITS DUE DATE"

Why are there 3 columns containing due dates? Is the requirement an OR operation? e.g.

If Date_Col1 OR Date_Col2 OR Date_Col3 is within 1 day Then send the email.

How do you want the code to be triggered? Will it be a once a day, manually run operation or are you looking for something that is more automated?

Do you need the macro to know whether an email has already been sent in order to prevent multiple emails to the same client?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

message edited by DerbyDad03


Report •
Related Solutions


Ask Question