I have been tasked with figuring out a way to automate a form letter process that currently is done mostly by hand with a lot of copy/paste. We have letters that need to get sent out based on our internal system. Someone now looks up the items in the system, inputs the information into a form letter and mails it. That's the simple version.
I need to create a program whereby they can pull the information from the database and then choose the specific form letter (or combination of multiples) that they want to send and have it populate the letter with other information from the database.
Is there a way to integrate this process into Reporting Services or do you have any other suggestions that I might research in building this project?