Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-24-2019, 08:25 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: 8
mdlewis is on a distinguished road
Default Merging multiple records

I'm new and have sent a longer version to the wrong group. But my problem is the same as in https://www.msofficeforums.com/mail-...-multiple.html and I get the same problem with this example. When I move from one merge record to the next, the displayed table does not update unless I rest the cursor on it and click "Update Field". Am I missing a Word/Merge setting?
Reply With Quote
  #2  
Old 01-24-2019, 08:32 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: 21,956
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

You're evidently only previewing the merge instead of completing it via Finish & Merge.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
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: 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
  #4  
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: 21,956
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
  #5  
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: 8
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
  #6  
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: 21,956
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
  #7  
Old 01-24-2019, 10:33 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: 8
mdlewis is on a distinguished road
Default

I have a client who generate the info from another package into a txt file which I will translate into relevant related tables. The master table is the merge data and I had hoped to link the related data into tables/database merge fields.

The client wants a document whose fields and layout may be added to, changed etc for any particular run - and then possibly changed again - several sources of massaging and data display. So the exercise may be repeated as if it were a single level document .

The subsidiary table info would be then be resourced afresh for each "re-run" so any already made change to generated documents, would be overwitten - same names.

I've thought of another way to give ultimate flexibility, if a subsidiary, non merge doc can be linked into a merge doc so that each main merge record can find the doc.

For a given set of records.

1. Place the table/database field into a separate - single level - merge doc based on the main merge dataset.
2. Run it and generate the doc for each instance into a carefully named ordinary word doc.

3. Run the main merge doc and dynamically add in a subsidiary (non merge) doc as generated above. (1:1) All fields would be changeable - the merge fields and layout and the local fields in the attached doc.

This depends on word merge being able to "link", "add in" a subsidiary carefully named doc.

As the number of records in the main set will not be very large, this may be possible using an extended If statement. The records in the set will always have a field 1,2,3,4, etc which appears as the start of the name of the parallel generated non-merge doc,. although a variably named "link" "add in" would be preferable.
Reply With Quote
  #8  
Old 01-24-2019, 10:37 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: 21,956
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

In that case - if you're not willing to do your editing post merge - instead of trying to coerce a mailmerge & DATABASE fields into doing what you want, perhaps you should consider hiring a programmer to developing something better suited to your needs.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


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 07:39 AM.


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