This application manages the data of the contacts that have relation with the Foundation, to carry out the sending of personalized letters, when events take place.
The structure and design of the data was personalized according to the client’s needs.
The letters are sent through the Word program, structuring the presentation by means of a template and programming the link from Access. The user only has to set the filters in the program and execute the combination to obtain the personalized letters.
We show some details of the application:
The application has a search engine for contacts:
The print management allows the printing of a list of contacts, by means of a filter, based on a field that establishes the type of contact:
For the combination of the data with letters, another filter is established, in which you have to select a letter model, establish the type of contact, select the language (Spanish or Catalan) and put the date for the letter:
Finally, the program has a section of auxiliary files, in which the way to greet contacts, the treatment given to them, the types of contacts and the positions they may have in a company are established. It also establishes the postal codes, towns and provinces, plus the different models of letter that you want to use, even if they are only for one time:
Application made with Access. To use this application you need MS Access and MS Word. The application is made in Spanish language. Note: The data inserted in the images are fictitious.