#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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 |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
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 |
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 |
insert database as field | david_89_ | Mail Merge | 3 | 03-26-2014 06:02 AM |