View Single Post
 
Old 06-06-2019, 10:08 AM
munchi12 munchi12 is offline Windows 10 Office 2010
Novice
 
Join Date: Jun 2019
Posts: 1
munchi12 is on a distinguished road
Default Merging data from excel into word?

Hi all, does anyone know if there is a function to merge multiple rows of data from an excel spreadsheet into a word document without using copy and paste?

I have a word template that im required to follow but i cannot do a copy paste method because one of the cells in the word document is a merged cell.

I would like to ask if it is possible to have the data be automatically transferred onto the word document much like a mail merge function but without creating an entirely new template.

E.g. to have data from Columns A-E from row 1 to fit into the word document with a table like below:
[A1][B1][C1]
[D1][E1]

[A2][B2][C2]
[D2][E2]

Is it possible to have the data for row 2 of my excel to fit in the same word document automatically? how do i get word to automatically recognise that it needs to go to the next row and fill in the data from the next row in excel?
Reply With Quote