View Single Post
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Delete Blank Lines with Word 2007 Mail Merge

Is the variable number of pieces of data in separate fields in the one
record or do you have multiple records that you want to combine into one
document where each of those records contains data that is common for that
document?

The first certainly can be done with the use of If...then...Else field
constructions, thought setting it up can be a bit monotonous for dealing
with 2, 3, 4, 5, 6, 7, 8, 9 or 10 pieces of data.

For the second, use the method on the following website:

http://cornell.veplan.net/article.aspx?&a=3815


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"SSJ" wrote in message
...
I have been researching this problem and have not found a good
solution. I attempted to use the IF function which does leave the
line blank, but does not actually delete the line. I am attempting to
merge data into a word file. The data to merge contains a different
number of rows depending on the prospect. Some letters will have 2
pieces of information to mail merge others will have up to 10. After
the portion of the letter that needs data merged the standard letter
continues.

What I would like to do is have the portion of the letter following
the merged data to continue after the last line of merged data. All I
have found to do so far is have a wide area of blank space between the
last merged data and the remaining portion of the letter.

For example if I merge in one letter 2 pieces of data, but it is set
up to hold 10 lines of data I have 8 blank lines between the merge and
remaining portion of the letter. Is there anyway to have the blank
space be dynamic for each letter?

Thanks!