Mail merge excel ke word

Mail merge is a powerful feature in Microsoft Word that allows you to combine data from an Excel spreadsheet with a Word document template to create multiple documents with unique information. Here's a step-by-step guide on how to do a mail merge from Excel to Word:

Prerequisites:

• Microsoft Excel 2010 or later
• Microsoft Word 2010 or later
• A Word document template with merge fields
• An Excel spreadsheet with data to merge

Step 1: Prepare your Excel spreadsheet

• Open your Excel spreadsheet and make sure it has the data you want to merge with your Word document.
• Select the entire data range (e.g., A1:E10) and go to the "Data" tab in the ribbon.
• Click on "From Text" and then "From Microsoft Query" to create a query that will connect your Excel data to Word.

Step 2: Create a Word document template

• Open a new Word document and create a template with merge fields. A merge field is a placeholder that will be replaced with data from your Excel spreadsheet.
• Use the "Insert" tab in the ribbon and click on "Quick Parts" > "Field" to insert a merge field.
• Choose the type of field you want to insert (e.g., "Name", "Address", etc.) and click "OK".

Step 3: Set up the mail merge

• Go back to your Excel spreadsheet and select the entire data range.
• Go to the "Data" tab in the ribbon and click on "From Microsoft Query" to connect your Excel data to Word.
• In the "Create a query" dialog box, select "Word" as the destination and click "OK".
• In the "Mail Merge" dialog box, select the Word document template you created earlier and click "OK".

Step 4: Map the fields

• In the "Mail Merge" dialog box, you'll see a list of fields from your Excel spreadsheet. Map these fields to the corresponding merge fields in your Word document template.
• Click "OK" to start the mail merge process.

Step 5: Preview and print

• Word will now create a new document for each record in your Excel spreadsheet, replacing the merge fields with the corresponding data.
• You can preview the merged documents by clicking on the "Preview Results" button.
• Once you're satisfied with the results, you can print or save the merged documents.

Tips and Variations:

• You can use multiple Excel spreadsheets as data sources for your mail merge.
• You can also use other data sources, such as Access databases or text files, as long as they can be connected to Word using Microsoft Query.
• To automate the mail merge process, you can use VBA macros in Excel or Word.
• You can also use third-party add-ins, such as Mail Merge Toolkit, to enhance the mail merge feature in Word.