How to automatically generate a word document from the text in each column in Excel?

Using Word's mail merge feature, you can do it in the following steps:

Save the excel document.

Please click Enter a description.

Create a new Word file, click on Mail > select recipients > use existing list.

Please click Enter a description.

Select your excel file in the selection window and select the sheet name.

Click Insert Merge Field and you'll see the two column headers you want to insert.

Please click Enter a description.

Insert the parts you want to insert into the appropriate positions.

Please click Enter a description.

Then select the content of the heading, and click in order: right-click --> paragraph--> outline level --> change to level 1.

Click Finish Merge to single file, and a file with all the contents merged into one word will be generated.

The display level is level 1, and only the title is displayed.

Then click Show Documents, then click Create, and you've created these documents, so click Save to save them to the appropriate location.

Please click Enter a description.

Please click Enter a description.

You can use File Batch Process Batch Replacement Cards on the main interface of the treasure chest.

It is recommended to use the Word mail merge function to achieve this method.

See the experience for yourself, many tutorials.

Merge with word mail, excel sheet as a list. No mail merge, at once. Learn in 10 minutes.

Prepare the data (excel format) that will be used to generate the clear document. Open the document of the standard and insert it into the data source in the order of each item in the document (the following will use simple data as an example).

Start by clicking on the quote in the word toolbar and then clicking on the message.

3.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.

4.The cursor can be dropped on any item, in no particular order, but it is best to insert them in order. The items on the document must be the same as the items selected in the insert field, then click Insert, and then click Close, and then insert the merged fields in turn

After each item is inserted, you must click to close, or it is a repeated insertion, (Note: if the operation is correct, the default is the database domain) If you are not careful, when inserting the merge field, accidentally click to other options in the toolbar, don't be in a hurry, directly click on the reference - the email can continue to be inserted.

5.After all the merged domains are inserted into the chain shed, it looks like this, reminding friends that they must check whether the insertion is correct again and again.

6.Once you've checked that everything is correct, click Merge to New Document in the toolbar.

7.That's what the final generation looks like.

1. First of all, open the excel file and copy an area in the file at will.

2. After that, open the Word document, select Paste, and then click Paste Special.

3. After that, it will automatically recognize the original ** file of the copy area, and after it is selected, the point impact will be determined below.

4. After that, you can paste it over.

5. After that, click Paste Format and select Match to Target Area ** style.

6. After that, you can successfully import the excel data into Word**.

The following are two tables in an excel workbook, Sheet1 and Sheet2, which are replaced by Table1 and Sheet2 respectively. We need to import the language scores from Table 2 into Table 1, but as you can see from the figure, the names of Table 1 and Table 2 do not correspond to each other.

Select Table 1 and select cell C2, which is the first grade to be entered in the language project. Select the Insert – Function command.

In or select a category, select Find & Reference

Select vlookup in the corresponding Select function and click OK.

In the Function Parameters panel that appears, click the button at the arrow of the first option.

Click on the name of "Zhang San", that is, the "A2" cell, which means that we want to find the result of "Zhang San", click the button above to return to the panel opening bar.

Click the button at the arrow of the second option.

Select Table 2 as shown in Huzhong, select both column A and column B, and click the button above.

Since the language score in Table 2 is in the second column, we fill in the number "2" for the third item

For the fourth item, we can directly fill in "0" and click OK.

We see that Zhang San's language score in Table 1 has a numerical value, which is the same as that in Table 2.

Select cell C2 and use the fill handle to pull down, and all the language scores will be filled in from Table 2 to Table 1.

The specific operation steps to fill in the data in Excel in batches into ** in Word are as follows:

1. First click to open the word application, click the "Insert" tab on the main page of this file, and then click "**" under the "Insert" tab.

2. Then click on the "Insert**" option in the pop-up option box.

3. Then click to go to the "excel" file you want to operate, select the data you need to operate with the mouse, and then click the "Ctrl+C" key on the keyboard.

4. Then open the word file, right-click in the first cell of ** that you just opened the settings, and then click in the pop-up option box to select "Paste".

5. Then you can see that the data selected in Excel has been successfully imported into Word.

Keep all the documents you want to modify in bulk in the same folder.

Please click Enter a description.

Before modifying, determine the content of multiple Word document files to be modified.

If the content to be modified is "Xiping County" in multiple word documents, please click to enter **Description.

Please click Enter a description.

Please click Enter a description.

Double-click Word Document Batch Processing Master

Please click Enter a description.

Click on "Select Catalog".

Please click Enter a description.

In the pop-up window, select and click the folder where the multiple word document files you want to modify in bulk are located, and then click the "OK" button.

Please click Enter a description.

All document files in the file are automatically added.

Please click Enter a description.

Click "Save List".

Please click Enter a description.

Enter a random name in the pop-up box and click the "Save" button.

Please click Enter a description.

Click in the Word document batch processing option and select "1. Content Batch Replacement".

Please click Enter a description.

Pop up on the right'Replace document content in bulk'In the box, enter the content to be modified under the "Put text:" tag, such as "Xiping County", and enter the content to be changed under the "Replace with:" tag, such as "I'm here".

Then click on the "Add as Pending Task" button.

Please click Enter a description.

If there are other items to be modified in bulk, click the "Add to List" button, then enter the next content to be modified, such as "Ah", under the "Put Text:" tab, enter the next content to be changed, such as "Ha", under the "Replace with:" tab, and then click the "Add to List" button.

After adding all the contents of the document to be modified to the list repeatedly, click the "Add as Pending" button.

Please click Enter a description.

Click the "OK" button in the pop-up window.

Please click Enter a description.

Click the "Yes" button in the pop-up window.

Please click Enter a description.

Click the "OK" button in the pop-up window.

Please click Enter a description.

When the system finishes processing, it will display "Mission completed!" ”

Please click Enter a description.

Open the file to view the result, multiple word document files are all completed in batches.

Please click Enter a description.

Please click Enter a description.

Please click Enter a description.

How to extract the corresponding data from ESTEL and generate it into a Word document in batches. This can be done directly in their settings.

The method of copy-pasting and inserting objects implements Excel** import into a Word document.

If you are troublesome and want to use a simple one, then use ready-made tools. Make the doc into a template document, check the box to replace it, and save it one by one, and check the data from each row in xls. This feature is similar to the mail merge feature.

It is very convenient to solve it with VBA macros.

1. Create a word document, write the unchanged parts well, and make some parts "bookmarked".

2. Build a macro in Excel.

This is a typical application of the Word Merge Mail feature.