ISO Best way to send pricing updates to customers

[Guest]

I need to be able to send out pricing changes to our customers via email.
Currently, there are 4 Sales Reps that have their own contacts in Outlook,
but I could easily create a Public Folder for Pricing Contacts if need be.
I have a .csv file that contains the pricing records for about 150-200
customers, each customer has between 1-200 individual parts/pricing records.
Each customer can only get their own records. The customers are assigned
unique numbers, so I have that to use as a join. I can also use SQL Server
if need be. I was going for an email/mail merge/excel combo, but now I'm
rethinking that since the Reps involved would want to review each email
before it goes out. So what about code that would activiate via a right
click on a contact??? Maybe?

Any ideas?

TIA
Kell

 

[Sue Mosher [MVP-Outlook]]

Not a right-click, but a menu or toolbar command could launch code related to the current contact.