Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-07-2020, 01:49 AM
rakesh seebaruth rakesh seebaruth is offline merge from excel to word Windows 10 merge from excel to word Office 2010 64bit
Novice
merge from excel to word
 
Join Date: Jul 2017
Posts: 2
rakesh seebaruth is on a distinguished road
Default merge from excel to word

Hello Guys

I have for example the following table in my excel sheet



Name Surname Adrdress Sex Mobile Number
BBB XXXX KKDJ M 1222
CCC DDD EDED M 1255
DDLF FFE ERR M 15

Is it possible to mailmerge directly the table instead of using insert mergefields ?

Thanks

rakesh
Reply With Quote
  #2  
Old 03-07-2020, 05:17 AM
macropod's Avatar
macropod macropod is offline merge from excel to word Windows 7 64bit merge from excel to 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

Well, in that case, it wouldn't be a mailmerge…

Beyond that, you can use:
• OLE to link your Word document to an Excel worksheet, such that when the data in Excel changes, Word is updated;
• a DATABASE field in Word to construct a table from data that conform to whatever rules you specify; or
• VBA to copy & paste a range from Excel into Word as a table.
No code is required for either of the first two methods.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Update & Unlink Specific Merge Field in Word Doc from Mail Merge - Excel VBA RMerckling Mail Merge 16 05-17-2018 05:19 PM
merge from excel to word Merge fields from Excel into word document Tonykiwi Word 5 10-11-2015 12:54 PM
merge from excel to word Merge From Excel With Table in Word - Next Record If Excel Column Same? misscrf Mail Merge 2 10-15-2014 11:51 PM
merge from excel to word Merge data from excel into word jonpackbosoxfan Excel 34 09-18-2013 08:38 AM
merge from excel to word Word Merge from Excel not in same order! Coreysan Mail Merge 3 12-11-2011 04:22 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:39 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