Mail Merge into a Word Table

[tlwaltz]

I would like to use Mail Merge, if possible, to create a Word table using data from Assess that essentially mimics an Access report. I have created a multi-record report in Access. But I want that multi-record "table" of information in a Word document.

I know that you can use Publish It to create a Word document, but the Word document that I have has a different format than the Access report. I'd like to use Mail Merge to export the multi-record table of data into a Word table/document.

Everything that I have seen regarding Mail Merge seems to create a separate Word document for each record of data. I want to create ONE Word table from a multi-record Access query using Mail Merge. Is that possible? If so, can you tell me how to do it?

Thanks
tw

 

[mhall56]

I have a Word 2007 Template Document with a Table that contains 4 merge fields in the main body of the document. It is set up as a 'Directory' type.

There is also set of merge fields in the Header section of the same Word Document which are static (they will contain the same value for each row of the text file data source). The values of the 4 merge fields in the table will vary from row to row.

When I run my VBScript it generates 1 page in the document for each row in the text file data source.

I can manually use the Mailings --> Finish & Merge --> Edit Individual documents --> Merge to New Document --> Merge “All” records to get the data from all the rows to display in the table on a single page.

How can I use a VBScript to populate the table with all the rows in the data source and keep tdo this?

If you reply
I can send you my word template, data source data file and VBScript file.

Best Regards,
Mitch Hall

 

[mhall56]

I would like to use Mail Merge, if possible, to create a Word table using data from Assess that essentially mimics an Access report. I have created a multi-record report in Access. But I want that multi-record "table" of information in a Word document.

I know that you can use Publish It to create a Word document, but the Word document that I have has a different format than the Access report. I'd like to use Mail Merge to export the multi-record table of data into a Word table/document.

Everything that I have seen regarding Mail Merge seems to create a separate Word document for each record of data. I want to create ONE Word table from a multi-record Access query using Mail Merge. Is that possible? If so, can you tell me how to do it?

Thanks
tw

I have the same problem. Do you have a VBScript you could share that prevents word from creating a separate document for each record of data?

Thanks!
Mitch Hall