How to mailing excel to word

There are several ways to mail merge Excel data into a Word document:

Method 1: Using Word's Built-in Mail Merge Feature

1. Open your Word document and go to the "Mailings" tab in the ribbon.
2. Click on "Start Mail Merge" and select "Step-by-Step Mail Merge Wizard".
3. Choose "Use an existing list" and select your Excel file.
4. Follow the wizard's prompts to select the fields you want to merge into your document.
5. Click "Finish" to merge the data into your document.

Method 2: Using Excel's Built-in Mail Merge Feature

1. Open your Excel file and go to the "Data" tab in the ribbon.
2. Click on "From Other Sources" and select "From Microsoft Query".
3. Create a new query and select "Word" as the destination.
4. Choose the fields you want to merge into your document.
5. Click "Finish" to merge the data into a new Word document.

Method 3: Using VBA Macro

1. Open your Excel file and go to the "Visual Basic" editor (press Alt+F11 or navigate to Developer > Visual Basic).

2. Create a new module and paste the following code:

   Sub MailMergeToWord()
    Dim wdApp As Object
    Dim wdDoc As Object
    Dim xlApp As Object
    Dim xlWorkbook As Object
    Dim xlSheet As Object
    Dim i As Integer
   
    Set wdApp = CreateObject("Word.Application")
    Set wdDoc = wdApp.Documents.Add
    Set xlApp = CreateObject("Excel.Application")
    Set xlWorkbook = xlApp.Workbooks.Open("YourExcelFile.xlsx")
    Set xlSheet = xlWorkbook.Sheets("YourSheetName")
   
    For i = 1 To xlSheet.UsedRange.Rows.Count
        wdDoc.Range.InsertAfter xlSheet.Cells(i, 1).Value
        wdDoc.Range.InsertParagraph
    Next i
   
    wdApp.Quit
    Set wdApp = Nothing
    Set wdDoc = Nothing
    Set xlApp = Nothing
    Set xlWorkbook = Nothing
    Set xlSheet = Nothing
   End Sub

3. Replace "YourExcelFile.xlsx" and "YourSheetName" with your actual file name and sheet name.

4. Run the macro by clicking "Run" or pressing F5.

5. The macro will create a new Word document with the merged data.

Method 4: Using a Third-Party Add-in

There are several third-party add-ins available that can help you mail merge Excel data into a Word document, such as:

• Excel-Word Mail Merge Add-in
• Mail Merge Tool for Excel
• Excel to Word Converter

These add-ins often provide a more user-friendly interface and additional features, such as formatting options and error handling.