#1
|
|||
|
|||
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? |
#2
|
||||
|
||||
Aside from mailmerge, which doesn't seem applicable here, there is no automatic function for this.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Quote:
|
#4
|
||||
|
||||
That is a necessary consequence of how mailmerge works. It is possible, though, to use a macro post-merge to join those tables.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Editing merged Word 2013 data before mail merging through Outlook | Masque42 | Mail Merge | 5 | 05-02-2017 03:45 PM |
Merging data from Two word documents based on number search | 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 |
[EXCEL 2010] Merging data from three different sheets | 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 |