Hi Amanda_G! I appreciate your suggestions, but I don't think it's exactly what I was looking for. Below are more specific examples to help explain what I am looking to achieve. We get clients’ name, email, car type and current mileage -Example: Mary Smith, Volvo XC-60, 12,000 miles -In 3 months, we would like to send Mary an email stating that, “Your car is likely reaching a needed oil change at 15,000 miles…” (add 3000 to mileage automatically in email) -And everyone in the “oil change list” gets 3,000 miles added to their mileage field in 3 months -Example 2: Bob Jones, VW 150,000 miles -In a year send Bob an email that “At 162,000 your VW needs annual transmission and fluid check” automatically adding 12,000 -And everyone in Transmission list gets 12,000 added to their car’s mileage -And in the future, we update the client fields with new mileage information based on actual car data, or new car update based on their email address I appreciate the help!
... View more
