Hi Graham,
yes I have the data source correctly sorted and I have choosen the document
type directory.
The strange behaviour is that I have downloaded also the macopod's example
files and they dont' work neither on my PC with Word and excel 2007, nor in
another machine with excel and word 2003.
As soon as I open the word file a popup window appears saying:
"If you open this document the following command will be executed:
Select * from c:\users\Waramanga\Documents\System\Catalogue Merge Data.xls
Do you want to continue?"
If I click on "Yes" a blank page opens. I have verified if the data source
is connected and it is.
Do you think that could be a problem the office language? I have Word and
Excel in Italian.
"Graham Mayor" wrote:
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 }}¶