Adding range values to email

Morning everyone

I have used a template from Ron Bruin to set up an automatic email when a value in column F reaches 14 which works fine but since make the changes to work in my own sheet I cannot get it to add the values for the columns A-E for the same row which worked in his examples.

I've attached the workbook and would be really grateful if anyone can help figure out why it no longer adds the additional details

Thanks

Mykal

You have deleted a vital bit of code somewhere which was telling VBA which cell is FormulaCell

To test this I inserted

Code:

---

Set FormulaCell = Worksheets("Broker Agreements").Range("D4")

---

Below the line

Code:

---

strsub = Format(Now, "DD-MMM-YYYY") & " - Upcoming Review Reminder:"

---

and it worked

FormulaCell drives all the values such as

Code:

---

Cells(FormulaCell.Row, "A").Value

---

Hopefully this will help you solve your puzzle

Hi Yongle

Thank you so much for you help - worked perfectly. I messed about with this all weekend but couldn't figure out what I had done.

As always I really do appreciate the help you guys give

Best wishes

Mykal