Adding range values to email

[mykal66]

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

[Yongle]

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

To test this I inserted

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

Below the line

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

and it worked

FormulaCell drives all the values such as

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

Hopefully this will help you solve your puzzle

[mykal66]

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