I need to be able to print a mass mailer from a database. This mailer will be custom to each customer. Each customer has different accounts, interest rates, and join dates. Each of these variable coupled with the contact info, will be used in the verbiage of the mailer. Will be applying mathmataical formulas to some of the data.
My rough draft plan for the chain of events is this:
Data is imported to sql database
Data is retreived
Account data is manipulated based on hard coded formulas
Standard sales pitch (template of some sorts) is filled in with contact info and manipulated account data
Message is printed to either a file or directly to the paper (prefer printing directly to paper because we will be doing these in batches of 2000+)
Rinse and repeat until X number of mailers are done
I am open to suggestion on improving/changing the chain of events as well as a method to accomplish this task.
Would like to do it in C# asp.net if possible.