Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-30-2015, 04:01 AM
kathriiin kathriiin is offline Mail merge into table with two colums and several rows Windows 7 64bit Mail merge into table with two colums and several rows Office 2010 64bit
Novice
Mail merge into table with two colums and several rows
 
Join Date: Mar 2015
Posts: 2
kathriiin is on a distinguished road
Default Mail merge into table with two colums and several rows

Hi,



I have a text in several languages and want to show Language1 in the left column and Language2 in the right column. I need the table so that every text starts at the same height. But whenever I put the next record command into the second column, everything gets displayed in language2.

Column1 Column2
Row1 «Title» «NextRecord»«Title»
Row2 «Text1» «Text 1»
Row3 «Text2» «Text 2»

Does anybody know how to solve this problem?

Thank you!!!
Reply With Quote
  #2  
Old 03-30-2015, 05:33 AM
gmayor's Avatar
gmayor gmayor is offline Mail merge into table with two colums and several rows Windows 7 64bit Mail merge into table with two colums and several rows Office 2010 32bit
Expert
 
Join Date: Aug 2014
Posts: 3,406
gmayor is a name known to allgmayor is a name known to allgmayor is a name known to allgmayor is a name known to allgmayor is a name known to allgmayor is a name known to all
Default

For this to work you would need your data source to have one language as Text1 and the other as Text2, for each record. You can then use a directory merge to merge to a single row two column table, with Text1 in cell1 and Text2 in cell2. Merge to a new document then add any supplementary information to the document. There would be no Next Record field required.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #3  
Old 03-30-2015, 05:48 AM
kathriiin kathriiin is offline Mail merge into table with two colums and several rows Windows 7 64bit Mail merge into table with two colums and several rows Office 2010 64bit
Novice
Mail merge into table with two colums and several rows
 
Join Date: Mar 2015
Posts: 2
kathriiin is on a distinguished road
Default

Thank you for your response!

The problem is that I have around 10 languages and 30 text fields per language in the excel file and I always select two languages which should be displayed afterwards right next to each other. That's why I would need the next record field. do you know what I mean? Is there any way to insert a formula saying that column 1 should be linked to language1?
Thanks!!
Reply With Quote
  #4  
Old 03-30-2015, 07:06 AM
gmayor's Avatar
gmayor gmayor is offline Mail merge into table with two colums and several rows Windows 7 64bit Mail merge into table with two colums and several rows Office 2010 32bit
Expert
 
Join Date: Aug 2014
Posts: 3,406
gmayor is a name known to allgmayor is a name known to allgmayor is a name known to allgmayor is a name known to allgmayor is a name known to allgmayor is a name known to all
Default

If you have 30 phrases and 10 languages, you should have thirty records (rows) with ten columns (one for each language) in your data source. Then you can use mail merge as I indicated by inserting the appropriate language fields in each of the cells.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge Multiple Rows Into One Document Grouped ryano Mail Merge 4 03-23-2015 04:27 PM
Mail merge into table with two colums and several rows Merge only the text in a table and keep the 2 original colums of a table james1979uk Word Tables 5 12-15-2013 05:48 PM
Mail merge into table with two colums and several rows Easy mail merge but want to suppress rows ClaireAMAdams Mail Merge 5 04-30-2013 02:43 PM
Mail merge into table with two colums and several rows Mail Merge multiple rows? ender541 Mail Merge 1 08-21-2012 03:14 PM
Mail merge into table with two colums and several rows Mail Merge to create specific number of table rows flackend Mail Merge 2 08-24-2011 11:49 AM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 12:30 PM.


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