Mail merge by data categories

Sorry Graham,
now I have understood. It was not clear to me that inside the "Catalogue
Mailmerge Tutorial.doc" there are the mailmerge fields that have to be copied
to the "Mailmerge Main Document".
It was due most probably to my bad english. Sorry for that. In any case
after having understood the tutorial I still have the problem. I did the
following steps:
1. Opened the "Mailmerge Main Document.doc" clicking yes to perform the
query and connect data source
2. Copied «Representative» and «Sales» fields from page 3 of the tutorial
3. Pasted the fileds on "Mailmerge Main Document".
4. Pushed the preview button to see the results. This is what it is showed:

ACT Canberra

Yang $2.100

5. Pushing the next button to see the following record I see

Roulston $4.000

So the first row disappered. This happen also for the following records and
also if I come back to the first record. The first record shows just the
following row

Yang $2.100

But the more strange thing that happen is: going back to steps 1 to 4, if
instead of pushing the next button, I simply iconize the word application, as
soon as I restore it the first row disappered.








"Graham Mayor" wrote:

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
}}¶

You have not completed the merge. You must merge to the printer or to a new
document. See
http://www.gmayor.com/mail_merge_lab...#only_one_page
which covers essentially the same issue.

--

Graham Mayor - Word MVP

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



nnetfabio wrote:
Sorry Graham,
now I have understood. It was not clear to me that inside the
"Catalogue Mailmerge Tutorial.doc" there are the mailmerge fields
that have to be copied to the "Mailmerge Main Document".
It was due most probably to my bad english. Sorry for that. In any
case after having understood the tutorial I still have the problem. I
did the following steps:
1. Opened the "Mailmerge Main Document.doc" clicking yes to perform
the query and connect data source
2. Copied «Representative» and «Sales» fields from page 3 of the
tutorial
3. Pasted the fileds on "Mailmerge Main Document".
4. Pushed the preview button to see the results. This is what it is
showed:

ACT Canberra

Yang $2.100

5. Pushing the next button to see the following record I see

Roulston $4.000

So the first row disappered. This happen also for the following
records and also if I come back to the first record. The first record
shows just the following row

Yang $2.100

But the more strange thing that happen is: going back to steps 1 to
4, if instead of pushing the next button, I simply iconize the word
application, as soon as I restore it the first row disappered.








"Graham Mayor" wrote:

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
}}¶

Graham I have completed the merge and the result is still strange because I
see only the key field displayed.
Looking the status bar on the bottom left I read:
Page: 1 of 1 | Words 122
By pushing the paragraph symbol the words appeared and the list is complete,
but if the paragraph is disabled I cannot see the list. Also if the paragraph
is enabled and I click on print preview I see only the first key field.


"Graham Mayor" wrote:

You have not completed the merge. You must merge to the printer or to a new
document. See
http://www.gmayor.com/mail_merge_lab...#only_one_page
which covers essentially the same issue.

--

Graham Mayor - Word MVP

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



nnetfabio wrote:
Sorry Graham,
now I have understood. It was not clear to me that inside the
"Catalogue Mailmerge Tutorial.doc" there are the mailmerge fields
that have to be copied to the "Mailmerge Main Document".
It was due most probably to my bad english. Sorry for that. In any
case after having understood the tutorial I still have the problem. I
did the following steps:
1. Opened the "Mailmerge Main Document.doc" clicking yes to perform
the query and connect data source
2. Copied «Representative» and «Sales» fields from page 3 of the
tutorial
3. Pasted the fileds on "Mailmerge Main Document".
4. Pushed the preview button to see the results. This is what it is
showed:

ACT Canberra

Yang $2.100

5. Pushing the next button to see the following record I see

Roulston $4.000

So the first row disappered. This happen also for the following
records and also if I come back to the first record. The first record
shows just the following row

Yang $2.100

But the more strange thing that happen is: going back to steps 1 to
4, if instead of pushing the next button, I simply iconize the word
application, as soon as I restore it the first row disappered.








"Graham Mayor" wrote:

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
}}¶

If you have inserted the appropriate fields into the mailmerge main document
and merged to a new document you should get the results in that new document
as shown in the relevant sections of tutorial. I certainly do here. I cannot
immediately spot where it is you are going wrong. No doubt macropod, whose
tutorial it is, will be along later to offer suggestions.

--

Graham Mayor - Word MVP

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



nnetfabio wrote:
Graham I have completed the merge and the result is still strange
because I see only the key field displayed.
Looking the status bar on the bottom left I read:
Page: 1 of 1 | Words 122
By pushing the paragraph symbol the words appeared and the list is
complete, but if the paragraph is disabled I cannot see the list.
Also if the paragraph is enabled and I click on print preview I see
only the first key field.


"Graham Mayor" wrote:

You have not completed the merge. You must merge to the printer or
to a new document. See
http://www.gmayor.com/mail_merge_lab...#only_one_page
which covers essentially the same issue.

--

Graham Mayor - Word MVP

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



nnetfabio wrote:
Sorry Graham,
now I have understood. It was not clear to me that inside the
"Catalogue Mailmerge Tutorial.doc" there are the mailmerge fields
that have to be copied to the "Mailmerge Main Document".
It was due most probably to my bad english. Sorry for that. In any
case after having understood the tutorial I still have the problem.
I did the following steps:
1. Opened the "Mailmerge Main Document.doc" clicking yes to perform
the query and connect data source
2. Copied «Representative» and «Sales» fields from page 3 of the
tutorial
3. Pasted the fileds on "Mailmerge Main Document".
4. Pushed the preview button to see the results. This is what it is
showed:

ACT Canberra

Yang $2.100

5. Pushing the next button to see the following record I see

Roulston $4.000

So the first row disappered. This happen also for the following
records and also if I come back to the first record. The first
record shows just the following row

Yang $2.100

But the more strange thing that happen is: going back to steps 1 to
4, if instead of pushing the next button, I simply iconize the word
application, as soon as I restore it the first row disappered.








"Graham Mayor" wrote:

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 }}¶

Thank you very much Graham now I have the necessary knowledge to troubleshoot
by myself.
You was very helpful,
Thank bye

"Graham Mayor" wrote:

If you have inserted the appropriate fields into the mailmerge main document
and merged to a new document you should get the results in that new document
as shown in the relevant sections of tutorial. I certainly do here. I cannot
immediately spot where it is you are going wrong. No doubt macropod, whose
tutorial it is, will be along later to offer suggestions.

--

Graham Mayor - Word MVP

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



nnetfabio wrote:
Graham I have completed the merge and the result is still strange
because I see only the key field displayed.
Looking the status bar on the bottom left I read:
Page: 1 of 1 | Words 122
By pushing the paragraph symbol the words appeared and the list is
complete, but if the paragraph is disabled I cannot see the list.
Also if the paragraph is enabled and I click on print preview I see
only the first key field.


"Graham Mayor" wrote:

You have not completed the merge. You must merge to the printer or
to a new document. See
http://www.gmayor.com/mail_merge_lab...#only_one_page
which covers essentially the same issue.

--

Graham Mayor - Word MVP

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



nnetfabio wrote:
Sorry Graham,
now I have understood. It was not clear to me that inside the
"Catalogue Mailmerge Tutorial.doc" there are the mailmerge fields
that have to be copied to the "Mailmerge Main Document".
It was due most probably to my bad english. Sorry for that. In any
case after having understood the tutorial I still have the problem.
I did the following steps:
1. Opened the "Mailmerge Main Document.doc" clicking yes to perform
the query and connect data source
2. Copied «Representative» and «Sales» fields from page 3 of the
tutorial
3. Pasted the fileds on "Mailmerge Main Document".
4. Pushed the preview button to see the results. This is what it is
showed:

ACT Canberra

Yang $2.100

5. Pushing the next button to see the following record I see

Roulston $4.000

So the first row disappered. This happen also for the following
records and also if I come back to the first record. The first
record shows just the following row

Yang $2.100

But the more strange thing that happen is: going back to steps 1 to
4, if instead of pushing the next button, I simply iconize the word
application, as soon as I restore it the first row disappered.








"Graham Mayor" wrote:

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 }}¶

You are welcome

--

Graham Mayor - Word MVP

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



nnetfabio wrote:
Thank you very much Graham now I have the necessary knowledge to
troubleshoot by myself.
You was very helpful,
Thank bye

"Graham Mayor" wrote:

If you have inserted the appropriate fields into the mailmerge main
document and merged to a new document you should get the results in
that new document as shown in the relevant sections of tutorial. I
certainly do here. I cannot immediately spot where it is you are
going wrong. No doubt macropod, whose tutorial it is, will be along
later to offer suggestions.

--

Graham Mayor - Word MVP

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



nnetfabio wrote:
Graham I have completed the merge and the result is still strange
because I see only the key field displayed.
Looking the status bar on the bottom left I read:
Page: 1 of 1 | Words 122
By pushing the paragraph symbol the words appeared and the list is
complete, but if the paragraph is disabled I cannot see the list.
Also if the paragraph is enabled and I click on print preview I see
only the first key field.


"Graham Mayor" wrote:

You have not completed the merge. You must merge to the printer or
to a new document. See
http://www.gmayor.com/mail_merge_lab...#only_one_page
which covers essentially the same issue.

--

Graham Mayor - Word MVP

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



nnetfabio wrote:
Sorry Graham,
now I have understood. It was not clear to me that inside the
"Catalogue Mailmerge Tutorial.doc" there are the mailmerge fields
that have to be copied to the "Mailmerge Main Document".
It was due most probably to my bad english. Sorry for that. In any
case after having understood the tutorial I still have the
problem. I did the following steps:
1. Opened the "Mailmerge Main Document.doc" clicking yes to
perform the query and connect data source
2. Copied «Representative» and «Sales» fields from page 3 of the
tutorial
3. Pasted the fileds on "Mailmerge Main Document".
4. Pushed the preview button to see the results. This is what it
is showed:

ACT Canberra

Yang $2.100

5. Pushing the next button to see the following record I see

Roulston $4.000

So the first row disappered. This happen also for the following
records and also if I come back to the first record. The first
record shows just the following row

Yang $2.100

But the more strange thing that happen is: going back to steps 1
to 4, if instead of pushing the next button, I simply iconize the
word application, as soon as I restore it the first row
disappered.








"Graham Mayor" wrote:

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 }}¶