![]() |
#1
|
|||
|
|||
![]()
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? |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
Masque42 | Mail Merge | 5 | 05-02-2017 03:45 PM |
![]() |
PRA007 | Word Tables | 6 | 11-23-2015 05:30 AM |
merging data sets in excel 2013 | nwiabrad | Excel | 9 | 07-24-2014 12:07 AM |
![]() |
bremen22 | Excel | 1 | 08-20-2013 10:00 AM |
Mail merging and pulling varying data from Excel | shannag1881 | Mail Merge | 0 | 10-05-2009 08:51 AM |