#1
|
|||
|
|||
Automatically fill word tables with excel data
Hi everybody,
I have multiple excel files which Always have the same format. Row 1 are the different categories (Adress, contact, name, etc) and under them are the data (Baker street 1, 0474 45 89 20, Patrick, ..), I included a picture to make this more clear. For each row of this excel file 2 new word pages should be made with on the first page some data from the row and on the second page some other data from the same row (see picture 2). I first thought about making a big table over the 2 pages in the word file and then automatically let the data from excel extract to this word table for each row. But this turned out to be harder then it should be. Any help is welcome and don't hesitate to ask questions. Kind regards, Lauren Van Roy |
#2
|
||||
|
||||
On the face of it this is a Letters type of mail merge.
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
Tags |
excel to word, tables and objects |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Using Excel data to automatically make Word documents | Vincent | Mail Merge | 9 | 01-04-2021 03:05 PM |
Populate Word Drop-down list with Excel column then auto fill form fields with Excel data | Faldinio | Word VBA | 7 | 10-19-2014 06:03 AM |
Data transfer from Word tables to Excel | shoro | Word | 4 | 10-01-2013 05:08 AM |
How to create an Excel add in that will automatically build tables from data | selvamariappan | Excel Programming | 1 | 12-12-2011 03:11 AM |
Automatically entering/fill data in cells in Excel 2003 | dipdog | Excel | 0 | 08-17-2006 08:37 AM |