Can i mail merge word document with excel

Yes, you can mail merge a Word document with an Excel spreadsheet. Here's a step-by-step guide to help you do so:

Prerequisites:

  1. Microsoft Word (2010 or later) and Microsoft Excel (2010 or later) installed on your computer.
  2. The Excel spreadsheet should have the data you want to use for the mail merge.
  3. The Word document should be set up with merge fields where you want to insert the data from the Excel spreadsheet.

Step-by-Step Instructions:

  1. Open the Word document: Open the Word document you want to mail merge.
  2. Go to the "Mailings" tab: In the Word ribbon, click on the "Mailings" tab.
  3. Click on "Select Recipients": In the "Mailings" tab, click on the "Select Recipients" button in the "Start Mail Merge" group.
  4. Choose "Use an Existing List": In the "Select Recipients" dialog box, choose "Use an Existing List" and then click on "Excel Spreadsheet".
  5. Browse to your Excel file: Browse to the location of your Excel spreadsheet and select it.
  6. Choose the worksheet and range: In the "Select Table" dialog box, choose the worksheet and range that contains the data you want to use for the mail merge.
  7. Click "OK": Click "OK" to close the "Select Table" dialog box.
  8. Insert merge fields: In your Word document, place your cursor where you want to insert the data from the Excel spreadsheet. Then, click on the "Insert Merge Field" button in the "Write & Insert Fields" group.
  9. Choose the field: In the "Insert Merge Field" dialog box, choose the field you want to insert from the Excel spreadsheet.
  10. Repeat steps 8-9: Repeat steps 8-9 for each field you want to insert.
  11. Preview and edit: Preview your mail merge document to ensure everything looks correct. You can edit the document as needed.
  12. Finish the mail merge: Once you're satisfied with the mail merge, click on the "Finish & Merge" button in the "Finish" group.
  13. Choose the output: Choose whether you want to print the document, save it as a PDF, or send it as an email.

That's it! Your Word document should now be mail merged with the data from your Excel spreadsheet.