Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #6  
Old 10-30-2014, 04:22 AM
macropod's Avatar
macropod macropod is offline Skipping row in mail merge table. Windows 7 64bit Skipping row in mail merge table. 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

One thing that concerns me is your reference to:
Record
Table Start
...
Table End
These are not Word fields, which suggests you're using some kind of 3rd-party addin. In that case, your options may be severely limited. Assuming your software allows it, for each transaction you could use a set of IF tests like:
{IF«Transaction1»<> "Fee*" «Transaction1»¶
"}{IF«Transaction2»<> "Fee*" «Transaction2»¶
"}{IF«Transaction3»<> "Fee*" «Transaction3»¶
"}

Note: The field brace pairs (i.e. '{ }') for the above example are all created in the document itself, via Ctrl-F9 (Cmd-F9 on a Mac); you can't simply type them or copy & paste them from this message. Nor is it practicable to add them via any of the standard Word dialogues. Likewise, you can't type or copy & paste the chevrons (i.e. '« »') - they're part of the actual mergefields, which you can insert from the mailmerge toolbar. The spaces represented in the field construction are all required. Instead of the ↵ and ¶, you should use real line/paragraph breaks.

The alternative is to not use your 3rd-party addin and instead use one of the Many-to-One Mail Merge add-ins, from:
Graham Mayor at http://www.gmayor.com/ManyToOne.htm; or
Doug Robbins at http://bit.ly/1hduSCB
These both work with Word's own mergefields. In addition to a 'Many to One' merge, the latter handles:
• Merge with Charts
• Duplex Merge
• Merge with FormFields
• Merge with Attachments
• Merge to Individual Documents
• Merge, Print and Staple
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Skipping row in mail merge table. Mail Merge on Optional Row(s) of a Table Chris Wong Mail Merge 3 08-21-2019 12:55 PM
Mail merge--skipping records 623bookends Mail Merge 2 01-12-2014 06:02 AM
Skipping row in mail merge table. mail merge with table nadja Mail Merge 5 03-06-2012 05:41 PM
Skipping row in mail merge table. Skipping pages in a mail merge NewGirl Mail Merge 6 12-16-2011 07:16 AM
Skipping row in mail merge table. Mail Merge Skipping 2 Labels when Printing mbsfirst Mail Merge 3 12-27-2010 04:28 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:54 AM.


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