Mail Merge and Grouping

[puppygirl3939]

I was wondering if by any chance anyone has been been able to create a mail merge in microsoft word with 2 groupings. Example Data:

Country City Name Title
USA Dallas John Manager
USA Dallas Brian Assistant
USA Florida Tom Assistant
Europe London Liz VP
Europe France Carmen Director
Europe France Bill Assistant

The result should be:

USA
Dallas
John, Manager
Brian, Assistant
Florida
Tom, Assistant

EUROPE
London
Liz, VP
France
Carmen, Director
Bill, Assistant

Here is the code I am using:
{If{MergeSeq}="1" "{Mergefield Country}
" ""}{Set Place1{Mergefield Country}}
{If{MergeSeq}="1" "{Mergefield City}
" ""}{Set Place1{Mergefield City}}
{If {Place2{Mergefield Country}}<>{Place1{Mergefield Country}}"
{Mergefield Country}
{If {Place2{Mergefield City}}<>{Place1{Mergefield City}}"
{Mergefield City}

{Mergefield Name}{Mergefield Title}" "{Mergefield Name}{Mergefield Title}"}{Set Place2{Mergefield Country}}

This is the result I am getting :

USA
Dallas
John, Manager
USA
Dallas
Brian, Assistant
USA
Florida
Tom, Assistant

EUROPE
London
Liz, VP
Europe
France
Carmen, Director
Europe
France
Bill, Assistant

Any suggestions!

 

[SkipVought]

Hi,

You're using mail merge, but NOT for a mailing, correct?

What are you REALLY trying to accomplish? Please state your overall objective.

Skip,
[sub]
[red]Be advised:[/red]To be safe on the FOURTH, don't take a FIFTH on the THIRD, or...
You might not come FORTH on the FIFTH! [/sub]

 

[puppygirl3939]

Correct, I am trying to create a word template in order to generate a directory based on a public contact folder from Microsoft Outlook. Currently our receptionist updates the employee contact folder in outlook and then she has to update the contact list template in word. This way she only updates the information in one place. She can mail merge from outlook and select the contact list template click merge and be done.

 

[SkipVought]

This REPORT is the kind of thing that is extremely simple to fo in Excel using a Pivot Table. I Copies the data into Excel, parsed it, and did the Pivot Table report ALL in less than 2 minutes.

Result...
[tt]
Country City Name Title
Europe France Bill Assistant
Carmen Director
London Liz VP
USA Dallas Brian Assistant
John Manager
Florida Tom Assistant
[/tt]


Skip,
[sub]
[red]Be advised:[/red]To be safe on the FOURTH, don't take a FIFTH on the THIRD, or...
You might not come FORTH on the FIFTH! [/sub]

 

[puppygirl3939]

It has to be done in word in order to use the template with our logo and formatting for our board books. Excel wont' work.

 

[SkipVought]

OLE -- embed Excel in Word!

Skip,
[sub]
[red]Be advised:[/red]To be safe on the FOURTH, don't take a FIFTH on the THIRD, or...
You might not come FORTH on the FIFTH! [/sub]