View Single Post
  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
SSJ SSJ is offline
external usenet poster
 
Posts: 4
Default Delete Blank Lines with Word 2007 Mail Merge

On Aug 21, 1:10*am, "Doug Robbins - Word MVP"
wrote:
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!- Hide quoted text -


- Show quoted text -


The data records I have are all in one row. The prospects name and
the data I want to merge about the prospect appear in the same row.
There is a possiblity of up to 10 columns of information for each
prospect. Not all prospects have 10 pieces of information. Some only
have 2 and others 8 or 10. When I attempt to set this up in word it
allows for 10 lines of information. In the case of a prospect with
only 2 lines of information there is a huge blank gap between the last
line of merged information and the remaining portion of the letter. I
simply want something that will remove the "gap" moving the remaining
letter up or down depending on the amount of lines needed for the
merged data.

I appreciate your help.