View Single Post
  #1   Report Post  
Saeed
 
Posts: n/a
Default Merge fields in word tables populate by a VBA query

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