CRM (see google) systems can get what you are asking working. However some in some companies dig in the heels when you move to CRM systems. But if you want to do this, this is what I've seen used.

No, I won't advise which to look at. If the CRM seller/supporter won't answer your questions then you move to the next one.
Bob