Mail Merge data between Word and Excel

0 nhận xét

Summary:

Mail merge is a tool that links between word and excel quite effective. It just helps us manage to track the fastest way, the most efficient on the list of schools excel, and help us to reduce the time to create text on a word for the same sample text, and can save the text on a page uniform. Generally the use of mail merge is very significant, especially in the administration.Mail Merge data between Word and Excel is the a good idea for your word. Have many helping about this. I have some tips for you about it
Mail Merge data between Word and Excel
Common Introduction
Mail merge is a tool that links between word and excel quite effective. It just helps us manage to track the fastest way, the most efficient on the list of schools excel, and help us to reduce the time to create text on a word for the same sample text, and can save the text on a page uniform. Generally the use of mail merge is very significant, especially in the administration.
Using simple mail merge as follows:
- Step 1: Create an excel spreadsheet fields (these fields will be created corresponding to the required information filled inside the word)
- Step 2: Fill in the corresponding information in the fields (note: for they shall use this excel table several times, each time a new request Reunited should born in the columns A1 to i1, j1, ... we should corresponding symbol set for each column, for example: f1, f2, ... fn, ... to link to easy). After filling out the information, then save and close the excel again.
- Step 3: Open the word has a format that corresponds to excel out (note this word to empty the fans need to fill out). Go to Tools / Letters and Mailings / Mail Merge. And sequential step instructions (from step 1 to step 6). Specific:
+ Step 1 of 6: normally we choose letters -> move to step 2
+ Step 2 of 6: select use the current document
+ Step 3 of 6: select browse and conect with corresponding excel document
+ Step 4 of 6: choice of fans who need to insert the word excel
+ Step 5 of 6: Insert the information from the fields in the excel in the blanks in the word (for example: The name of the word will be an insert corresponding to f1 column: the column that includes information on date of birth)
+ Step 6 of 6: Show results: All the characters f1, ... fn will be converted into the corresponding information

If you are using Office XP, do it like this.
1. Create an Excel file before, with columns at your disposal, for example Excel file named Data.xls has the following columns correspond to the columns A / B / C / D, and then save the file to somewhere on the drive hard ID / Name/Birthday / address / ...

2. Open the Word, the form of the text drafted stirrer, note blank spots automatically enter text into

3. Select the Tools menu / Letter and mailing / Mail Merge Wizard ...

4. Task pane of Word appear for you to select the parameters of mixing, for example, you select Letter, and then click Next.

5. At the next step select the Use the Current Document, click Next: select recipients ...

6. Select the Use an existing access list, then click the Browse link below.

7. Select Data Source dialog box appears, select the Excel files in the Files Of Type box list box, and then pointing to your Excel file (for example Data.xls file mentioned above).

8. Select Tables dialog box appears, you enroll in the sheet item to choose the sheet, for example, sheet1 $. (If the first line of the column named Excel file as mentioned above, then click the checkbox First row of data contains column headers

9. Mail Merge Recipients dialog box appears for you to choose the line want to include mail, then select the latest default. Click OK

10. Then all the dialog screen disappears and the like ... nothing happened. If you click next: write letter của always in the task pane, nothing happen.

11. Choose View / Toolbars / Mail Merge toolbar to appear mixed mail.

12. Move to the spot to fill is blank, click the Insert Merge Field button (Right Insert Word Field button on the left) on the Mail Merge toolbar to appear there to appear the Insert Merge Field dialog box. Select Database Fields button, you will see the name of your column.

13. Now select one by one, click Insert, then click Close to move to a new site, repeat step 11 above until fully inserted into the correct columns each corresponding spot. Then click Next on the Task Pane. Click Next: Preview your letters always, because there is no need to make you interested in Step 4 this.

14. Through step 5, if you like that then click Next to Step 6, select Print to print always otherwise click Edit to edit the individual letter into the file. Choose All in the box to New documents Merge to merge the entire list did.

Facebook Comments
Blogger Comments
Share knowledge

Copyright © 2016 - Share knowledge ®