Updated email text color (darker)
Send affiliate checks, edit the affiliate letter before sending, test that letter prints out on printer so address shows through the envelope window.
Setup letter to go to Texas courts, fit the letter into windowed envelopes, print out to the 1,785 Texas courts that I already imported into SQL Server. Added bit field to database to fllag when letter is mailed so it is not resent.
Added table to database for social, yelp, and other review urls by website so that when we send affiliate letters these urls can be included for customer affiliates to go to and post reviews, share, etc to make more referral sales.
-- Here is a screen capture of the page that enters in the social/review sites to the database. Now when email goes out to affiliates it gives the affiliate a link to go to and post about the traffic school to bring in customers to their affiliate code