Did you have the data source sorted by location and did you set the merge
document type to directory?
Fellow MVP 'macropod' has posted a tutorial on this, with working field
codes and a sample Excel data source, at:
http://www.wopr.com/cgi-bin/w3t/show...?Number=731107
--
Graham Mayor - Word MVP
My web site
www.gmayor.com
Word MVP web site
http://word.mvps.org
nnetfabio wrote:
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 }}¶