Use excel database to create letters

• Project ID:

  411353

• Project Type:

  Fixed

• Budget:

  $30-$250 USD
  

Project Description:

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.

Skills required:

Excel

Additional Files:

Letter template.doc sample file for letter confirmation.xls