The phone number that the SMS appointment reminder will be sent to will be the phone number that is on the customer's profile at the time that the SMS message is sent out. This means that if you change the customer's phone number within the his or her profile after they have completed a booking, the SMS message will be delivered to the number that you updated their profile with.