Thread: Merge field source data field
View Single Post
 
Old 03-21-2013, 12:57 AM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
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
Hi kckay,

You can't reference a non-existant field in a mailmerge, at any level. Doing so will always generate errors when you complete the merge. Accordingly, you will need to either:
• add the field name to all the workbooks; or
• test each source file (eg via a macro) and delete the mergefield from the mailmerge main document before completing the merge.
The second approach, of course, carries the risk that the updated mailmerge main document will then be saved without the mergefield and other merges using that mailmerge main document against data files that do include the field won't reflect that fact.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote