Use excel database to create letters

I need an overnight solution for this project

I am looking for a solution as to how I might efficiently access information from an excel database

The database contains 3963 rows, each row having 13 columns. I attach a sample of the database and letter template. The database represents pre loaded details for companies that we are aiming to acquire as customers. The Key identifier is the businesses post code (zip code). Once registered we wish to issue a confirmation letter to each business.

My aim is to have a have a letter template that will form the basis for the confirmation letter. I want to be able to input a post code as a search term into some sort of form and for the database to be searched for the appropriate entry. Once the post code is found in the database the required information fields listed in that row will be automatically entered into the appropriate spaces in the template letter.

I realise that I could generate a mail merge but this not the solution I want. I want to be able to quickly generate a single letter for each business one by one as they subscribe. We currently are registering 100 businesses per day.

I work with Microsoft office 2003 – I have acess to Microsoft Office 2003 Word, Excel and Access. I can download open office if required.

I am paying for the information on how to configure my current software to achieve my aim. I am not asking for a 3rd party to generate the letters. I will do this myself.

Taidot: Excel

Näytä lisää: generate letter excel, create letter excel, generate letters excel, use database, excel database template, use excel database, create letter excel database, create letters database, generate letter excel database, database letters, create letters excel, create letters, use excel database word letters, use excel database create letters, access database create letters, create letters word acess, use excel database word forms, letter template excel, create investor letter database, create letter database, template letter import excel database, excel generate letter, generate letter excel word, attach template letters access database, use template excel letter

Tietoa työnantajasta:
( 8 arvostelua ) Wotton-under-Edge, United Kingdom

Projektin tunnus: #411353