Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-24-2019, 09:15 PM
mdlewis mdlewis is offline Merging multiple records Windows 7 64bit Merging multiple records Office 2010
Novice
Merging multiple records
 
Join Date: Jan 2019
Posts: 11
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
  #2  
Old 01-24-2019, 09:18 PM
macropod's Avatar
macropod macropod is offline Merging multiple records Windows 7 64bit Merging multiple records Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,355
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by mdlewis View Post
Thanks for your very fast reply. However, it does not solve my problem. I want each record - including table, editable before finishing.
That simply isn't possible - neither mailmerges in general nor DATABASE fields in particular - permit that. What's the objection to doing the edits post-merge?
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 01-24-2019, 09:41 PM
mdlewis mdlewis is offline Merging multiple records Windows 7 64bit Merging multiple records Office 2010
Novice
Merging multiple records
 
Join Date: Jan 2019
Posts: 11
mdlewis is on a distinguished road
Default Editable / Updatable Database fields.

Thanks "macropod".

I understand - a typical record set would be less than 10 - in the merge set.

The process would be

Start merge
Change non-table/database fields and layout for particular exercise.
Finish merge into separate docs and modify (no longer linked) table info on each as required.

Will work - but if the non-table fields needed further change - the whole modify table approach would be overwritten. The "further change" scenario is very likely.

As Malcolm 1 quoted, "Life wasn't meant to be easy"

Michael
Reply With Quote
  #4  
Old 01-24-2019, 10:05 PM
macropod's Avatar
macropod macropod is offline Merging multiple records Windows 7 64bit Merging multiple records Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,355
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

If your mailmerge main document is properly formatted and you use the appropriate query parameters and field coding, there shouldn't be any post-merge editing to do.

I have no idea what you mean by:
Quote:
Originally Posted by mdlewis View Post
if the non-table fields needed further change - the whole modify table approach would be overwritten
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Merging multiple records Merging multiple excel records in to a single word doc? dns_to Mail Merge 1 10-20-2017 01:22 PM
Merging multiple records Mail Merge is merging onto separate pages & not printing all records Tindomerel Mail Merge 4 10-01-2017 03:30 PM
Merging multiple records Mail merging reports with different numbers of records on each page chrisbarnettuk Mail Merge 1 11-11-2015 01:14 PM
Merging multiple records into one document LaniKaye Mail Merge 3 10-28-2014 05:56 PM
Help with consolidating multiple records into one wbiggs2 Excel 0 11-30-2006 01:02 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:16 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft