Mail Merge is one of the useful features of MS Word. Mail Merge allows you to create a MS Word document that contains special merge fields and combines this document with a data source. The data source replaces the merge fields with real data.
For example, if you want to inform all the customers of your company about a discount, you will use the same body text and then insert names and addresses from the Customer table of your MS Access database.
PayLessGainMore is offering a discount on its products and wants to send letters to all its customers. Each letter should have the first name, last name, mailing address, state & zip code of customers based on a generic document. Greg wants to use Mail Merge for this purpose. He wants to use the Customer table of the database as the data source.
Here are the Steps :
- To open the MS Word Mail Merge Wizard box in MS Access 2007, select the Customer table from the PayLessGainMore database and select External Data option from the menu on top .Go to More tab and select Merge it with Microsoft Office Word option.
- The Microsoft Word Mail Merge Wizard will open up. To create a new document and link the data to it, chose the Create a new document and then link the data to it option.
3. To insert the database fields in the new document, select the Mailings option from the menu & in that, select the Insert Merge Fields tab to select the desired fields and then click Finish & Merge tab.
4. To view the other records in the merge document, you can use the record locator button on the toolbar as displayed in this figure :
