Hello all,

I am currently trying to create a dynamic table with word mail merge. I have data coming into vb code from a database, and that data is being sent to a "data.dot" file (where the text moves vertically rather than horizontally. Do not know what its called specifically).

From there the data is being loaded into a word template with merge values.

Does anyone know if this is possible? And if so, when moving sets of data that would populate a dynamic table, are the values sent in through an array, or do there need to be multiple different variables for each data set being passed in?



Thank you for your help.

-Njacobs

Yes, what you want to do is possible.

You haven't provided enough information to answer your other questions. If you are using VBA code then either an array or lots of variables can be used. If the data is coming from a database then perhaps a recordset from a sql query would make the most sense to use.

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia

The data.dot files might be an in house thing honestly. Essentially we are calling our database to bring in certain values into the vb code, and from there the data is being moved into the "data.dot" file, which then moves the data into the template.

The data.dot file has a really weird format, where the variables being plugged into the template go vertically instead of horizontally. Not sure if this is a general standard, or if my company created this.

We actually have an in-house application that allows users to generate letters to be sent out. So that is the basis of the vb code.

Hope that helps clear things up.

We can't tell you how your code works without seeing your code. What exactly are you asking for here?

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia

Who is "we"? Got a mouse in your pocket mate?

Also I was just trying to elaborate more on my first post, because you said I did not provide enough information, but did not point me to what you did not understand.

What I am trying to get help for is moving data from vb code into a dynamic table in a MS Word template. I am moving data through merge fields. I need to know if I should move the data through some sort of array or just have multiple variables in the vb code.

For each "person" data being moved, there are multiple attributes that need to be filled into the table as well. So the more "persons" there are, the more rows I will need in the table. If there are only 4 people, I will need 4 rows. If there are 8 people, I will need 8 rows. And so on.

Further, what do I need to do in order to make the table dynamic. Is this something I would need to do in the vb code, or in the template? In the research I have done I have seen people put the data into excel, or put actual vb code in the template itself, among other things. I am wondering what the best way would be to go about doing this.

Thanks much!