Mail Merge program:
Problem:
Most of the monthly letters were created using Crystal
Reports. However, the one-off letters had to be created manually because not
all the information were saved to the database. Letters were created one by
one using the word's mail merge feature. A manual time consuming task
Solution:
A custom solution was designed in MS Excel™
to pull available information from SQL database
and any additional information can be entered by users on the excel user
form. Once all required data is generated, its saved to another excel file
and merged to word template with a click of a button. Once the letters are
printed, the data is archived to an Access database
Sample Screen shots:
Main Screen (Navigation screen different letter templates)
