How to import Excel documents into Word documents from many households in batches?

There should be an import or file type conversion.

Open the Excel electronic file that you want to insert into the Word document.

Click the cell you want to insert into the Word document and select the menu command "Insert" "Object".

In the New tab of the Object dialog box, select the object type Microsoft Office Word Document, and click the OK button.

At this time, a word document box will appear in excel, and the content will be entered directly in it, in exactly the same way as in the word Chinese file.

You can resize the Word document object by dragging the handles around it as you need, or you can move the mouse to the edge and change its position by dragging. When finished, you can click the mouse on a cell other than the object to exit the state.

At this time, if you click on the word document object, you will see that the handles around it have become round, and you can drag the position of the word object and change its size like dragging a drawing object, which is very convenient to operate. Double-click the object to enter the state again.

In addition to the above method of creating a new word document object, you can go to step 3, select "Create from file", and then click "Browse Command" in the dialog box, find the existing word document, and after you have finished selecting, go back to the dialog box, and click the "OK" button. Word documents inserted into Excel documents can be double-clicked to open at any time.

If you want to use the Word document saved on the hard disk or other storage, but do not want to increase the size of the Excel document, you can check the box "Link to File" in the dialog box, so that when you modify the source file, the changes in the source file will also be reflected in the Excel document.

With both of the above methods, there is a checkbox "Show as icon", if it is checked, only one icon will be displayed in the excel document. Double-click the icon to start Word on the document.

You can insert word document objects in excel electronics, and excel electronics objects can also be inserted in word, which can draw inferences.

First click on the quote in the word toolbar, and then click on Mail God. At this point, the toolbar shows that it is a mail merge, then click Open Data Source to find the data you need to import**, click Open to open. The cursor can be dropped on any item, in any order, but it is best to insert them in order.

Open the Word document, click on the menu bar "Mail Select Contacts Using an existing list". pop-up window, select Excel you want to import. pop-up window, click on the worksheet, click on OK Early.

Open the excel file that we need to insert into the word document. Click the file menu indicated by the arrow in the menu bar, and click Save As, which is indicated by the arrow. Name the file name, select the save type as a single file web page, select the save type as the entire excel sheet or select the worksheet, click the arrow to save.

The following describes the method of using the "mail merge method" to import Excel data into Word** in batches.1Open the word document that needs to be merged by mail and browse for the data you want to insert.

2.In the menu bar--- mail menu--- Start Mail Merge --- Mail Merge Step-by-Step Wizard, and the Mail Merge dialog bar appears on the left side of the document.

3.Select the document type as Letter (send the letter to a group of people, you can format the letter), and click Next to continue.

4.Click Next (Starting Document) - Select Start Document, that is, you need to set up the letter, check "Use Current Document", and click "Next".

5.Click Next (Select Recipients) - Select Recipients, tick "Use List Now", and click "Browse". Use a name and address from a file or database. , select a data source, find the address of the data source to be added--- select **, the name sheet1$, and select the first row of the data contains column headers. And click the OK button,-- select "Mail Merge Recipients" to check the required recipient list, you can not adjust the recipient list here, such as: sorting, filtering, finding duplicate recipients, finding recipients, verifying addresses--- click OK.

6.Go back to the "Mail Merge" column, select Next: Write a letter, check "Other Items" - "Insert Merge Field" appears, and select the content of the domain according to the content of the merged mail.

For example, add a name field to the name field, add a gender field to the gender field, and so on. When you're done inserting, tap Close.

Click Next to preview the letter --- you see the first record.

7.Click "Next" to complete the mail merge--- to complete the merge, you can already use "mail merge" to generate letters--- click "single letter" - choose to merge all records. On the left, you can see the entire content of the record.

At this point, you can print the content you need.

First, complete the list and data calculation on Excel. Then save the file in a convenient place to find.

Open Word and select the "Insert" button in the menu bar where you need to import.

In the insertion options, select Object.

Click "Create from File" in the object dialog box, then click "Browse", find the Excel file you just saved, click "Insert", and then click "OK".

You can see the created ** in word, click **, you can set the format of **, shirt selling posture such as "centered". Click on the dots in the four corners and drag to resize.

end method 2:

Select all cells of ** in Excel (the color will change after selection), and then right-click and select "Copy".

In word, move the cursor to the compatibility position that needs to be imported, right-click, and paste it. You can also adjust ** according to the operation of method 1.