Forum Discussion
Automatically send multiple emails based on calculated cell value
I have a spread sheet that counts down automatically the days left on clients service agreements. I would like to send automated email/emails every 7 days in the pink and yellow ranges. Each email wo...
I have looked at and tried the Ron de Bruin code but it wont allow me to copy and paste to another work book. Also I cannot find where to adjust text for the email or anything else except the final calculated number. Have spent hours on it to no avail. It comes up with the following when pasted into another workbook. Please find attached his workbook and snippets of the error plus my experiment worksheet (that doesn't work...) that produces the error with the copy and pasted VBA code.
Help !! 🙂
