Experience Level: Expert
Programming needed which will automate Excel/Open Office Calc spreadsheet management/ updating/triggered emails among several salespeople. Daily, each salesperson needs assigned leads [to be imported from existing Access database] incorporated with his/her entered data based on day\'s sales activities. Management needs complete updated sheet to include all activities and data for all salespeople. Leads are assigned by state. Would like triggered emails to be automated based on salespersons entry in Field XX and Field XY to automatically record date email sent. Other details... sorry I am new to posting here and not familiar with technical terms and best language to describe problem. Solution must accomodate at least 5 salespeople, prefer unlimited scalability.
There are no clarification messages.