Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-30-2021, 01:47 AM
huynguyen865 huynguyen865 is offline Ref field to Database field doesn't update properly in Mailmerge Windows 10 Ref field to Database field doesn't update properly in Mailmerge Office 2019
Novice
Ref field to Database field doesn't update properly in Mailmerge
 
Join Date: Aug 2021
Posts: 2
huynguyen865 is on a distinguished road
Exclamation Ref field to Database field doesn't update properly in Mailmerge

I have this following Word template:


which connects to a different excel workbook (the mergefield and table are in 2 different sheets)

However, I found that the table isn't updated properly during mailmerge. Sometimes, it's matched to wrong record, sometimes it's failed to populate, and somehow at the end it creates a whole new record (with table only).



I suspected something was going wrong during the update, and tried to update each record manually in Preview. Turned out to properly populate the Ref field inside the table, you have to refresh everything twice. Is there any way to fix/hack this behavior and makes it work in mailmerge? I know about MailMerge addin but this is for distribution within org so simple/portable method (that doesn't require additional install) is very much preferred.

Thanks in advance.

Last edited by Charles Kenyon; 08-30-2021 at 03:48 AM.
Reply With Quote
  #2  
Old 08-30-2021, 07:30 AM
huynguyen865 huynguyen865 is offline Ref field to Database field doesn't update properly in Mailmerge Windows 10 Ref field to Database field doesn't update properly in Mailmerge Office 2019
Novice
Ref field to Database field doesn't update properly in Mailmerge
 
Join Date: Aug 2021
Posts: 2
huynguyen865 is on a distinguished road
Default

I got it working by placing the Set Database field above the Ref.

Imgur: The magic of the Internet
Seem like Word updates fields in order as it appears on the document.

Last edited by huynguyen865; 08-30-2021 at 07:30 AM. Reason: image is not working
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Ref field to Database field doesn't update properly in Mailmerge Macro to insert an image to a word mailmerge document based on the value of a mailmerge field? Jake93 Mail Merge 3 07-02-2019 05:38 PM
Ref field to Database field doesn't update properly in Mailmerge database field table lines Sarki76 Mail Merge 3 06-26-2019 03:13 PM
Database field cell alignment scubadunc Mail Merge 9 08-12-2014 11:02 PM
Ref field to Database field doesn't update properly in Mailmerge insert database as field david_89_ Mail Merge 3 03-26-2014 06:02 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:45 PM.


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