There are some text reminder apps at the iTunes store, but none of them automatically send the text. I believe the only way to do so is to jailbreak your iPhone. There is (was) an app called biteSMS for jailbroken iPhones that will send a text at a scheduled time.