View Single Post
  #2   Report Post  
Suzanne S. Barnhill
 
Posts: n/a
Default

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