Mail Merge utility!!!
We all know that MS-Word has wonderful feature called MailMerge for merging a Letter with many address and print individual letters. The same functionality can be implemented in EXCEL. The new EXCEL Mail Merge workbook can found new uses!!!
- A Bill / Receipt
- A Data Fillup Form
- An Account Voucher
- etc
In the simplest form, the workbook will have 3 sheets
- LETTER: Where you will type the Letter
- LIST: The list of addresses (or data to be printed)
Now the question is how can we view the Printing Page. I may suggest two ways:
- View Individuals Letters/Forms
- View Group of Letters/Forms
I amusing the INDEX function to fetch the respective data from LIST sheet into PRINTPAGE sheet by referring the sequence number in the list. You can use VLOOKUP function to fetch data based on NAME or ID field.
A bigger images of those two sheets are follow :
