Mail merge

[Guest]

I have created some merge documents all connected to one datasouce. In some
of the documents I have some empty fields. When I go to use skip or next
field if blank, it does nothing. Is there a way to remove the empty fields so
my document is showing all the data without empty rows in between?

 

[Graham Mayor]

You can conditionally insert the fields if there is content eg
{Mergefield fieldname1}{If {Mergefield Fieldname 2} <> "" "
{Mergefield Fieldname2}"}

ie if mergefield2 has content insert a line break and write the content.
Otherwise ignore.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Graham Mayor]

You can conditionally insert the fields if there is content eg
{Mergefield fieldname1}{If {Mergefield Fieldname 2} <> "" "
{Mergefield Fieldname2}"}

ie if mergefield2 has content insert a line break and write the content.
Otherwise ignore.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Guest]

When I open the document that reflect for infomation that has some blank
fields, I do not want the empty spaces to show in my document. I have placed
the information in a table and do not want blank rows. Why is the "skip next
if blank" not working?

 

[Cindy M -WordMVP-]

Hi =?Utf-8?B?dHNhbQ==?=,

When I open the document that reflect for infomation that has some blank
fields, I do not want the empty spaces to show in my document. I have placed
the information in a table and do not want blank rows. Why is the "skip next
if blank" not working?

There is no way to conditionally suppress a table row. Not with "Skip Next" or
"IF" or anything else.

You should use a filter to take these rows out of the data source BEFORE the
merge is executed. We can help you with that if you provide more information

1. What's the data source?
2. Which version of Word are you using?
3. What criteria determine whether you have a "blank row"?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail

 

[Guest]

1. The data source is what ever is linked to the mail merge in word.
2. The version of word I am using is Microsoft Office Word 2003
3. The blanks are showing up because the fields in the database are blank.
What is the purpose of "skip next if blank" if not for this? I am not trying
to suppress the table row I am trying to get the data in the database not to
show up in the table if the field is blank. Hoping it will skip to the next
if blank, so the information shows up consecutively in the rows without the
blanks.
Hope you can help....

 

[Cindy M -WordMVP-]

Hi =?Utf-8?B?dHNhbQ==?=,

1. The data source is what ever is linked to the mail merge in word.
2. The version of word I am using is Microsoft Office Word 2003
3. The blanks are showing up because the fields in the database are blank.
What is the purpose of "skip next if blank" if not for this? I am not trying
to suppress the table row I am trying to get the data in the database not to
show up in the table if the field is blank. Hoping it will skip to the next
if blank, so the information shows up consecutively in the rows without the
blanks.

This field is old, old, old - comes from the days before Word even had tables.
The Help says this, and more. Do as the Help says, and set a proper filter:

<<Compares two expressions. If the comparison is true, SKIPIF cancels the
current merge document, moves to the next data record in the data source, and
starts a new merge document. If the comparison is false, Microsoft Word
continues the current merge document.

You may find the SKIPIF field used in documents created in previous versions of
Word, but don't use the SKIPIF field in the current version of Word. You can
select data records more easily by using the Mail Merge Recipients dialog box,
which appears when you connect to a data source during a mail merge.

Notes

A merge (MERGEFIELD) field used in an expression refers to data in the current
data record, not in the next data record.
Don't use the SKIPIF field with the NEXT field. >>

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail