Consider the following:

Create a word document which contains a table of 2 rows and 3 columns.
The first row has headers ("Boilerplate text")
The second row has mail merge fields in each cell, c1, c2, c3

Using VBA, I want to do the following:

Run a query
For each row returned
Loop

assign column values from the current row to c1, c2, c3

if more rows, add another row to the word table
End Loop

Now, I could have just one row and place all values for the columns in
the corresponding merge field and use the carriage return to put each
"row" on a different line, but the problem with this is lining up each
"row".

The reason for using VBA is so that this can be invoked from a Java tool
(thats how they do the current far simpler documents).



Saeed

ng_786

If I correctly understand what you're trying to do, it is simpler to do this
using a simple merge. If you create a single-row table containing your merge
fields and generate a catalog/directory merge, you will get one table row
for each data record. You then go back and add the table headings.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"Saeed" wrote in message
...
Consider the following:

Create a word document which contains a table of 2 rows and 3 columns.
The first row has headers ("Boilerplate text")
The second row has mail merge fields in each cell, c1, c2, c3

Using VBA, I want to do the following:

Run a query
For each row returned
Loop

assign column values from the current row to c1, c2, c3

if more rows, add another row to the word table
End Loop

Now, I could have just one row and place all values for the columns in
the corresponding merge field and use the carriage return to put each
"row" on a different line, but the problem with this is lining up each
"row".

The reason for using VBA is so that this can be invoked from a Java tool
(thats how they do the current far simpler documents).



Saeed

ng_786

In message , Suzanne S. Barnhill
writes
If I correctly understand what you're trying to do, it is simpler to do this
using a simple merge. If you create a single-row table containing your merge
fields and generate a catalog/directory merge, you will get one table row
for each data record. You then go back and add the table headings.


Thanks Suzanne, two follow on questions

1. Can I invoke this catalog/directory merge via calls to a VBA module.

2. Can I have multiple tables of different types (rows and columns) each
with placeholders/merge fields for different queries being inlcuded in
the same document?

As an aside (and just an aside - I'm just trying to fit in with the way
things are done and get the job done) ,the reason why VBA is important
is because the client uses a Java tool that maps Java to VBA for
invoking an application that produces word documents with merged fields
from an Oracle database. New documents require that the designer produce
a VBA module that does the basic word, and then this can be easily
tramslate to the Java stuff for inclusion in the application.


Saeed

ng_786

I can't answer your questions, but I would suggest that more appropriate
forums would be microsoft.public.word.mailmerge.fields and any in the
microsoft.public.word.vba hierarchy.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"Saeed" wrote in message
...
In message , Suzanne S. Barnhill
writes
If I correctly understand what you're trying to do, it is simpler to do
this
using a simple merge. If you create a single-row table containing your
merge
fields and generate a catalog/directory merge, you will get one table row
for each data record. You then go back and add the table headings.


Thanks Suzanne, two follow on questions

1. Can I invoke this catalog/directory merge via calls to a VBA module.

2. Can I have multiple tables of different types (rows and columns) each
with placeholders/merge fields for different queries being inlcuded in
the same document?

As an aside (and just an aside - I'm just trying to fit in with the way
things are done and get the job done) ,the reason why VBA is important
is because the client uses a Java tool that maps Java to VBA for
invoking an application that produces word documents with merged fields
from an Oracle database. New documents require that the designer produce
a VBA module that does the basic word, and then this can be easily
tramslate to the Java stuff for inclusion in the application.


Saeed

ng_786