Mail Merge using variable data in Excel
I would like to create a merge document using variable data in Excel. The data in my Excel spreadsheet appears as indicated below. In Column1, the number may be repeated 5 to 10 times. However, the numbers in column3 may vary. The data in column4 will be either Yes/No.
Column1 Column2 Column3 Column4
1234 Housewares 23 No
2071 Housewares 54 Yes
In the Word document, the information in Column1 will be added within a paragraph. The other three columns information will be placed in a table. The length of the table will vary depending on the total numbers in Column1.
How can I merge the data from Excel into a Word document. There will about 500 letters I will need to generate. Therefore I need a simplified method to do so.
I am using Office 2010. Any suggestions?
|