Mail Merge using variable data in Excel

dewestone · #1 12-20-2016, 11:19 AM

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?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Mail Merge with variable table length MS Word 2013	rbr	Mail Merge	6	11-18-2016 07:05 AM
Mail merge at large table with variable number of rows	blar	Mail Merge	1	10-19-2015 03:04 PM
Is data merge and mail merge the same thing?	ikearns	Mail Merge	1	09-12-2014 03:53 AM
Collation of mail merge data	Nibbles	Excel	2	04-16-2013 07:59 AM
replace data from variable with "sub and super script" from excel to word by vba	krishnaoptif	Word VBA	9	06-22-2012 05:08 AM