Thread: [Solved] Merging multiple records
View Single Post
 
Old 01-24-2019, 09:15 PM
mdlewis mdlewis is offline Windows 7 64bit Office 2010
Novice
 
Join Date: Jan 2019
Posts: 8
mdlewis is on a distinguished road
Default Thanks - Works if you finish. BUT without finishing?

Thanks for your very fast reply. However, it does not solve my problem. I want each record - including table, editable before finishing. I can see that I will have to generate the table as a field in my source data. Just a BIT of VBA pre-processing. The original table approach with DATAFILE would have been read only, if it had worked.

But there is a curly one, why does the manual Update Field command update the current record's table values and is there any VBA which really detects change of record, enabling a VBA, update of the table - for that record?

If I add the standard "before or after mailmerge routine to the VBA, it does NOT fire up when there is a change of record BUT does - for every record in the merge set, when I do the manual Update field for the table/database instance.

I still think that I will need to create the table value(s) into the original merge dataset.

Thanks, Michael
Reply With Quote