Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-06-2019, 10:08 AM
munchi12 munchi12 is offline Merging data from excel into word? Windows 10 Merging data from excel into word? Office 2010
Novice
Merging data from excel into word?
 
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
  #2  
Old 06-07-2019, 09:31 PM
macropod's Avatar
macropod macropod is offline Merging data from excel into word? Windows 7 64bit Merging data from excel into word? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Aside from mailmerge, which doesn't seem applicable here, there is no automatic function for this.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 06-11-2019, 05:44 AM
kilroyscarnival kilroyscarnival is offline Merging data from excel into word? Windows 7 64bit Merging data from excel into word? Office 2010
Expert
 
Join Date: May 2019
Posts: 344
kilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nice
Default

Quote:
Originally Posted by munchi12 View Post
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?
I've used mail merge to do essentially the same thing, transfer info from an Excel worksheet into a Word form which is a table with customized cells (some merged, some not). For my purposes, though, each Excel record generates a separate small table, rather than one continuous Word table.
Reply With Quote
  #4  
Old 06-11-2019, 04:10 PM
macropod's Avatar
macropod macropod is offline Merging data from excel into word? Windows 7 64bit Merging data from excel into word? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Merging data from excel into word? Editing merged Word 2013 data before mail merging through Outlook Masque42 Mail Merge 5 05-02-2017 03:45 PM
Merging data from excel into word? 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
Merging data from excel into word? [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

Other Forums: Access Forums

All times are GMT -7. The time now is 08:34 AM.


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