Mail Merge Formatted Table from Access to Word

[Guest]

I want to merge and entire table from Acces to Word, complete with formatting.

I can get records from a table to appear from my Access table in Word , but
what if the number of records periodically changes? The formated table in
Word will then become obsolete. Is it possible for the table (the actual
formatting that displays borders around the records, etc) to be able to
contract or expand based on the number of records in the Access table? I
haven't figure out how to do this, and the options in Microsft Query don't
appear to allow for much formatting. Thanks, Ruben.

 

[pietlinden]

I want to merge and entire table from Acces to Word, complete with formatting.

I can get records from a table to appear from my Access table in Word , but
what if the number of records periodically changes? The formated table in
Word will then become obsolete. Is it possible for the table (the actual
formatting that displays borders around the records, etc) to be able to
contract or expand based on the number of records in the Access table? I
haven't figure out how to do this, and the options in Microsft Query don't
appear to allow for much formatting. Thanks, Ruben.

There's a function that does that in Access Developer's Handbook.
they create an ADO recordset in Access, create a delimited recordset
and then use ConvertTextToTable in Word... The good news is you can
record macros in Word to do all the manipulation you want... so you
don't have to figure most of it out at all.

 

[Guest]

P,

thanks for your reply. is there a way to create an ADO and delimited
recordsets via an Access query?

Also, I am not familiar with Word ConvertTexttoTable functionality. I did a
Help Menu search and did not find the topic. I'm fairly familiar with
recording macros in Word, but I'm sure where to start in this case - using
the mail merge function or...?

I am running Access and Word 2000.

Thanks for any help. Ruben.