I am rather new to the Word world. I would like to ask the best method of
automatically (via macro) creating a document. I need a document (maybe
more than one page) that has two columns. I will access a database to
supply the data to fill the two columns. I have this part working fine. I
just am wondering the best way to accomplish this. I am thinking that I
should use two tables and fill the tables with a loop. I think this would
work but I was wondering if anyone has suggestions or even examples. I am
very experienced with Exel and using a database to supply the data for the
spreadsheet. This is my very first Word programming try!

Thanks in advance

What sort of columns are we talking about? Newspaper style or is what you
really want to do to place the data from one field in the database into one
column and the data from another field into another column.

If it's the former, I would suggest that you create a template with the two
columns set up in it (via Format Columns) and then you use the Documents.Add
command to create a new document from that template.

If it's the later, then I would suggest that you use a catalog or directory
type mailmerge with the table in the database as the datasource and with the
mailmerge main document set up as a one row two column table with the
mergefields in the cells of that table. Then when you execute the merge to
a new document, a row will be added to the table for each record in the
database.
--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP
"JimS" wrote in message
...
I am rather new to the Word world. I would like to ask the best method of
automatically (via macro) creating a document. I need a document (maybe
more than one page) that has two columns. I will access a database to
supply the data to fill the two columns. I have this part working fine.
I
just am wondering the best way to accomplish this. I am thinking that I
should use two tables and fill the tables with a loop. I think this would
work but I was wondering if anyone has suggestions or even examples. I am
very experienced with Exel and using a database to supply the data for the
spreadsheet. This is my very first Word programming try!

Thanks in advance