#1
|
|||
|
|||
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> |
#2
|
||||
|
||||
Try the attached. I'll leave it to you to adjust the Styles to suit your formatting requirements.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Gracias, Macropod !
Many , thank you very much!!! The code is great, as you are. A greeting! |
#4
|
|||
|
|||
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 !!! |
#5
|
||||
|
||||
You need to use a Directory merge, not a Letter merge.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#6
|
|||
|
|||
Gracias, Macropod !
Many , thank you very much!!! |
#7
|
|||
|
|||
That solves my problem too!
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
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 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? | ender541 | Mail Merge | 1 | 08-21-2012 03:14 PM |