Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-12-2018, 03:14 AM
Octane1 Octane1 is offline Legal Document Mail Merge - How do I automate the deletion of empty clauses Windows 10 Legal Document Mail Merge - How do I automate the deletion of empty clauses Office 2013
Novice
Legal Document Mail Merge - How do I automate the deletion of empty clauses
 
Join Date: Dec 2018
Posts: 1
Octane1 is on a distinguished road
Default

Hi all,

Thanks for reading and any help you can provide.

I have a working mail merge that lifts info from an excel sheet into a legal document / contract.

In certain circumstances, a clause may not have any text next to it.

In the event of an empty clause I would like to automatically remove the clause number and the blank line below.

Thanks again for any assistance you can provide.

Oli

As an example.

1.1 The person concerned is x.



1.2 The person earns Y.

1.3

1.4 How much does it cost?
Reply With Quote
  #2  
Old 12-12-2018, 03:48 PM
macropod's Avatar
macropod macropod is offline Legal Document Mail Merge - How do I automate the deletion of empty clauses Windows 7 64bit Legal Document Mail Merge - How do I automate the deletion of empty clauses Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
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

If your 1.3 paragraph is otherwise empty and the 1.3 is generated by auto-numbering, the mailmerge should suppress it.

As for the empty line between paragraphs, you really shouldn't have that; inter-paragraph spacing should be managed via the paragraph space before/after settings.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Legal Document Mail Merge - How do I automate the deletion of empty clauses Mail merge: remove empty rows when a field is not showed Yarikh Mail Merge 4 09-23-2018 12:17 AM
Legal Document Mail Merge - How do I automate the deletion of empty clauses How can I automate the mail merge process in word for making labels using the 5160 Avery template? zrobles Mail Merge 5 08-07-2015 02:07 AM
automate macro for merged document (after merge) eibst Word VBA 1 06-05-2015 11:36 PM
Mail Merge Empty Data Field Licos101 Mail Merge 2 04-10-2014 06:19 AM
Legal Document Mail Merge - How do I automate the deletion of empty clauses Automate daily mail merge JCInfo Mail Merge 4 12-02-2013 05:12 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:15 AM.


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