zonenax.blogg.se

For example, the recipient list is a Microsoft Access database file or an Excel worksheet. The recipient list is a database that contains the data that is to be merged into the output documents. It may contain a letterhead, text, and instructions in merge fields for inserting text (such as recipient names and addresses) that vary from one output document to another. The main document contains the basic text that is the same in all of the output documents. When you use the Word Mail Merge feature, Word merges a main document with a recipient list to generate a set of output documents: This article explains how to use the Mail Merge feature in Microsoft Word to create and to print form letters by using data from a Microsoft Excel worksheet. You may go with Excel, Access or other Data sources including DDE(Dynamic Data Exchange) method.How to use the Mail Merge feature in Word to create and to print form letters that use the data from an Excel worksheet Like, start from Word and while connecting to the Mailing Data you may have many choices. Next is insert fields to Merge and arrange them.įinally Preview and finish the Mail Merge and save this File as Template.Īnother Method should be the Reverse of the above procedure.

Hit existing list, find Excel file, if required edit the Recipient's list. Like start with Blank File, Go to Mailing TAB, find Select Recipients. You need to perform usual Mail Merge procedure. For this Text Import Wizard help you to get data as TXT or CSV file into Excel. NB: If you don't want to use Excel data source, you can use a contact list or an address book in a TXT or CSV file. Since these headings will be used as Field Name in Word while Mail Merge. Like First Name, Last Name, Address1, Address2, City, State, Zip Code. In Excel enter Mailing data with appropriate Headings. Perform the Mail Merge from Excel, using the Excel Sheet as Database, you need to perform the following task.