Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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
 
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
In typing dates in Word, i.e. "January 12" how do you keep the "1. Carol Microsoft Word Help 2 January 12th 05 08:09 PM
word xp crashes after macros are recorded kharris0405 Microsoft Word Help 3 January 11th 05 10:50 PM
WP Delay Code - Word Equiv Mike G - Milw, WI Microsoft Word Help 6 January 10th 05 04:12 PM
mail merge problem - "Word found locked fields during the update.. zgaryt Tables 1 January 9th 05 01:04 PM
macro in word js Microsoft Word Help 1 December 28th 04 03:01 AM


All times are GMT +1. The time now is 05:30 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"