[macropod[_2_]]

Hi Graham,

It seems I'm going to have to add some text to the mailmerge main document to tell the eager beavers to read the tutorial!!

--
Cheers
macropod
[MVP - Microsoft Word]


"Graham Mayor" wrote in message ...
The page is blank because it IS blank. You still haven't read the tutorial!

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



nnetfabio wrote:
Graham, I don't mind about the popup message, it's not a problem, the
problem is that the page is blank even if I press SHIFT+F9 or ALT +
F9 (in my italian version). No fields are shown.
Do you have any other example that I can try?
Thanks
Fabio


"Graham Mayor" wrote:

The main document is supposed to be empty initially - have you read
the tutorial document that accompanies it?
The security message can be suppressed -
http://support.microsoft.com/?kbid=825765. See also the Word macro
to toggle the registry setting referred to in that link at
http://www.gmayor.com/word_vba_examples.htm#SQL.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




nnetfabio wrote:
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
}}¶