Abstract: A system and a method for generating a message for a customer are provided. The method includes retrieving data associated with a vehicle dealership ID from the first database. The data includes a repair order having a first record having a repair order ID, a repair order status, a customer ID, and the vehicle dealership ID. The data further includes a customer table having a second record including the customer ID, the vehicle dealership ID, and a customer telephone number. The method includes storing the data in a second database, and retrieving the first record from the repair order table in the second database. If the repair order status corresponds to the first order status, the method includes generating a first formatted message, based on the vehicle dealership ID, the customer ID, and the customer telephone number.