repeated data in mail merge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Gonat - 13 Dec 2005 16:48 GMT

At times when I do a merge data from a proceding filed is inserted into a
label if the field for that label is blank. Example: Row A has Microsoft as
company name, Rows B C and D have no company name but when merged A, B and C
all have Microsoft as company name and row D does not. Does not always
happen and does not happen for all records.

Reply to this Message

Graham Mayor - 14 Dec 2005 12:13 GMT

This shouldn't happen if you merge to a new document, but you can
conditionally place the Company field
eg

{Mergefield Name}{IF{Mergefield Company} <> "" "
{Mergefield Company}"}
{Mergefield Address}

Signature

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

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> At times when I do a merge data from a proceding filed is inserted
> into a label if the field for that label is blank. Example: Row A
> has Microsoft as company name, Rows B C and D have no company name
> but when merged A, B and C all have Microsoft as company name and row
> D does not. Does not always happen and does not happen for all
> records.

Reply to this Message