#1
|
|||
|
|||
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 |
#2
|
||||
|
||||
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] |
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 fields from Excel into word document | Tonykiwi | Word | 5 | 10-11-2015 12:54 PM |
Merge From Excel With Table in Word - Next Record If Excel Column Same? | misscrf | Mail Merge | 2 | 10-15-2014 11:51 PM |
Merge data from excel into word | jonpackbosoxfan | Excel | 34 | 09-18-2013 08:38 AM |
Word Merge from Excel not in same order! | Coreysan | Mail Merge | 3 | 12-11-2011 04:22 PM |