I need someone to fix three things that were done incorrectly by a previous programmer:
1. A script on our back office currently reminds salespeople of their next follow up via an email automatically sent to them. This needs to be fixed so that the salespeople will receive an email that states the CUSTOMER to which they are supposed to call.
2. If you look at screenshot one, you will see that the destination and orgin cities are not consisitent with puncuation and therefore are repeated in the SQL database. On screenshot two, the origin and destination cities fields must become dropdowns of already entered cities, where you can add or delete cities as well.
3. Finally, the third screenshot are the sales reports, everything is fine here except the formula to calculate the percentages is incorrect. Should be an easy fix.