Microsoft Office Forums Automatically fill word tables with excel data

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-12-2019, 12:10 AM
Qontrax Qontrax is offline Automatically fill word tables with excel data Windows 10 Automatically fill word tables with excel data Office 2013
Novice
Automatically fill word tables with excel data
 
Join Date: Jun 2019
Posts: 3
Qontrax is on a distinguished road
Default 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
Attached Images
File Type: png Question Excel.PNG (18.6 KB, 10 views)
File Type: png Question Word.PNG (8.1 KB, 10 views)
Reply With Quote
  #2  
Old 06-12-2019, 12:39 AM
gmayor's Avatar
gmayor gmayor is offline Automatically fill word tables with excel data Windows 10 Automatically fill word tables with excel data Office 2016
Expert
 
Join Date: Aug 2014
Posts: 2,761
gmayor is just really nicegmayor is just really nicegmayor is just really nicegmayor is just really nice
Default

On the face of it this is a Letters type of mail merge.
__________________
Graham Mayor - MS MVP (Word)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
Reply

Tags
excel to word, tables and objects

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
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
Automatically fill word tables with excel data Using Excel data to automatically make Word documents Vincent Word 7 04-30-2014 05:20 AM
Data transfer from Word tables to Excel shoro Word 4 10-01-2013 05:08 AM
Automatically fill word tables with excel data 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


All times are GMT -7. The time now is 10:29 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft