Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 03-21-2013, 12:57 AM
macropod's Avatar
macropod macropod is offline Merge field source data field Windows 7 64bit Merge field source data field Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,512
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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Field not showing in Pivot Table Field List kmcovington Excel 0 10-26-2012 10:14 AM
Merge field source data field How can I revise Excel data source in merge? navysalad Mail Merge 6 01-07-2012 06:50 PM
Merge field source data field Mail Merge - If a field is black, take the data from the row below? mikeprent Mail Merge 5 01-05-2012 04:52 AM
Formula to subtract one month from due date field in reminder field ghumdinger Outlook 1 10-01-2011 12:09 AM
Mail Merge data source on network drive Brandi Mail Merge 0 06-13-2010 11:26 AM

Other Forums: Access Forums

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


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