Results 1 to 3 of 3

Thread: deleting paragraphs if no data during mail merge in word

  1. #1
    VBAX Newbie
    Joined
    Jan 2016
    Posts
    4
    Location

    deleting paragraphs if no data during mail merge in word

    Trying to run a mail merge and have options or code delete numbered paragraphs where the merged field returns no value.
    Example of mergefield code:
    numbered paragraphs.JPG

  2. #2
    Actually what you need to do is INSERT the paragraph when the field has value. The field will presumably have a monetary amount or zero or nothing. The following assumes a monetary amount or nothing. The plan therefore is to add the condition to the end of the previous paragraph. In autonumbered paragraphs the sequence will look a little odd - as shown in the screenshot, but it all works itself out and the numbering will be correct when the merge is run.

    Example.jpg
    Graham Mayor - MS MVP (Word) 2002-2019
    Visit my web site for more programming tips and ready made processes
    http://www.gmayor.com

  3. #3
    VBAX Newbie
    Joined
    Jan 2016
    Posts
    4
    Location
    Thanks that did it! The trick was actually running the merge to see the results. Again many thanks!

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •