How to use mail merge to create a list sorted by category in Word

N

nnetfabio

Hi I'm trying to implement the following mail merge
http://support.microsoft.com/kb/294686/en-us

I followed the instructon perfectly but it doesn't work. The result should be:
Atlanta

Galos $3,000
Delaney $50,000
Henningsen $10,000

Houston

Johnson $8,000
Kelly $9,000
Pak $0

But in my case I obtain

Atlanta

Galos $3,000

Atlanta

Delaney $50,000

.... etc

so the grouping mechanism doesnt' work. It seem that the MERGESEQ didn't
work and also the carriage return (ENTER key). I'm using excel and word 2007

_______________________________________
This is the script. Field braces are inserted pressing CTRL+F9 and the
carriage return is done by press the ENTER key.

{ IF { MERGESEQ } = "1" "{ MERGEFIELD CITY }¶
" "" }{ SET Place1 { MERGEFIELD CITY }}¶
{ If { Place2 } <> { Place1 }"¶
{ MERGEFIELD CITY }¶
¶
{ MERGEFIELD EMPLOYEE } { MERGEFIELD SALES }" "{ MERGEFIELD EMPLOYEE } {
MERGEFIELD SALES }" }{ SET Place2 { MERGEFIELD CITY }}¶
 
C

compwiz22

Were you ever able to find a solution to this? I am in need of this solution
as well. Thanks in Advance
 
C

CyberTaz

Did you read the reply to the post to which you responded? The message was
posted by a user of Win Office who was directed to the appropriate group for
the reason stated in that reply. This group deals with the Mac version as
indicated by the .mac. In the group address.

If you're using a Windows version of Word you need to do as the OP was
directed. If you're using a Mac version submit a NEW message stating all
particulars about your version, OS, and details of your situation.

Regards |:>)
Bob Jones
[MVP] Office:Mac
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top