|
|
#1
12-20-2016, 11:19 AM
|
|||
|
|||
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? 
|
| Thread Tools | |
| Display Modes | |
|
|
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 |
Windows 10 
Office 2016
Threaded Mode