Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-23-2016, 03:13 PM
luisaranda luisaranda is offline Mail Merge Multiple Rows -word(from Spain) Windows 7 64bit Mail Merge Multiple Rows -word(from Spain) Office 2007
Novice
Mail Merge Multiple Rows -word(from Spain)
 
Join Date: Nov 2015
Posts: 4
luisaranda is on a distinguished road
Default Mail Merge Multiple Rows -word(from Spain)

Hi. I write from Spain . My English is painful . Please , someone tell me , what code would be necessary to create this multi-level structure
1.MADRID

1.1.CALLE LUCAS

1.1.1NUMERO3

1.1.1.1 FONTANERO


1.1.1.2.ALBANIL

1.1.2 NUMERO4
........................
I've tried dozens of times, but I can not and Spanish can not find anything about it. A million thanks(I know press CTRL+F9.I used this, but I get nothing
{ IF { MERGESEQ } = "1" "{ MERGEFIELD City }" "" }<ENTER>
{ SET Place1 { MERGEFIELD City }}<ENTER>
{ If { Place2 } <> { Place1 }"<ENTER>
{ MERGEFIELD City }<ENTER>
<ENTER>
{ MERGEFIELD Employee }{ MERGEFIELD Sales }" "{ MERGEFIELD Employee }{ MERGEFIELD Sales }" }{ SET Place2 { MERGEFIELD City }}<ENTER>
Reply With Quote
  #2  
Old 02-23-2016, 05:57 PM
macropod's Avatar
macropod macropod is offline Mail Merge Multiple Rows -word(from Spain) Windows 7 64bit Mail Merge Multiple Rows -word(from Spain) Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
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

Try the attached. I'll leave it to you to adjust the Styles to suit your formatting requirements.
Attached Files
File Type: docx Directory.docx (25.4 KB, 45 views)
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 02-23-2016, 11:36 PM
luisaranda luisaranda is offline Mail Merge Multiple Rows -word(from Spain) Windows 7 64bit Mail Merge Multiple Rows -word(from Spain) Office 2007
Novice
Mail Merge Multiple Rows -word(from Spain)
 
Join Date: Nov 2015
Posts: 4
luisaranda is on a distinguished road
Default

Gracias, Macropod !
Many , thank you very much!!!
The code is great, as you are.
A greeting!
Reply With Quote
  #4  
Old 02-25-2016, 03:25 PM
luisaranda luisaranda is offline Mail Merge Multiple Rows -word(from Spain) Windows 7 64bit Mail Merge Multiple Rows -word(from Spain) Office 2007
Novice
Mail Merge Multiple Rows -word(from Spain)
 
Join Date: Nov 2015
Posts: 4
luisaranda is on a distinguished road
Default

Hello again,Macropod
Sorry for the inconvenience. Your code is fantastic, but I am unable to get to see all the records on the same page .
Please could you help me do that.

Now I see this:


Página 1

1.MADRID
1.1.CALLE LUCAS
1.1.1NUMERO3

1.1.1.1 FONTANERO
1.1.1.2.ALBANIL


Página 2

1.BARCELONA
1.1.CALLE ESTMABRE
1.1.1NUMERO62

1.1.1.1 CIRUJANO
1.1.1.2.ESCULTOR



I would like to see this

Página 1

1.MADRID
1.1.CALLE LUCAS
1.1.1NUMERO3

1.1.1.1 FONTANERO
1.1.1.2.ALBANIL


1.BARCELONA
1.1.CALLE ESTMABRE
1.1.1NUMERO62

1.1.1.1 CIRUJANO
1.1.1.2.ESCULTOR



....................... ETC.


A million thanks !!!
Reply With Quote
  #5  
Old 02-25-2016, 04:19 PM
macropod's Avatar
macropod macropod is offline Mail Merge Multiple Rows -word(from Spain) Windows 7 64bit Mail Merge Multiple Rows -word(from Spain) Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
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

You need to use a Directory merge, not a Letter merge.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #6  
Old 02-25-2016, 11:22 PM
luisaranda luisaranda is offline Mail Merge Multiple Rows -word(from Spain) Windows 7 64bit Mail Merge Multiple Rows -word(from Spain) Office 2007
Novice
Mail Merge Multiple Rows -word(from Spain)
 
Join Date: Nov 2015
Posts: 4
luisaranda is on a distinguished road
Default

Gracias, Macropod !
Many , thank you very much!!!
Reply With Quote
  #7  
Old 03-06-2016, 09:32 AM
Skybluekid Skybluekid is offline Mail Merge Multiple Rows -word(from Spain) Windows 7 32bit Mail Merge Multiple Rows -word(from Spain) Office 2010 32bit
Novice
 
Join Date: Mar 2016
Posts: 3
Skybluekid is on a distinguished road
Default

That solves my problem too!
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge Multiple Rows -word(from Spain) mail merge multiple rows within a grouping tracygleghorn Mail Merge 12 11-12-2015 06:43 AM
Formula that can merge multiple rows with the same ID into one row Hilwey Excel 3 07-08-2015 08:50 PM
Mail Merge Multiple Rows -word(from Spain) Mail merge into table with two colums and several rows kathriiin Mail Merge 3 03-30-2015 07:06 AM
Mail Merge Multiple Rows Into One Document Grouped ryano Mail Merge 4 03-23-2015 04:27 PM
Mail Merge Multiple Rows -word(from Spain) Mail Merge multiple rows? ender541 Mail Merge 1 08-21-2012 03:14 PM

Other Forums: Access Forums

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


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