Mail megre Address Problem

[tapnawk99]

hi,
i'm newbee on mailmerge function.
Right now, i have excel file that contrained address fields.
e.g.
col A colB colC
1 Flat Street Zip
2 18 xxxx st 950
3 yyyy st 913
4 12 jjjj st

Then i wan to mail merge on my document as following

Flat 18 ZIP 950
xxxxx st

ZIP 913
yyyy ST

Flat 12
jjjj st

I can easily inset those word "Flat" and "ZIP".
But if the cell is blank, it should not t print the word "Flat" and
"zip". possible?

tap
thanks

 

[Graham Mayor]

You need two conditional fields:

{IF {Mergefield Flat} <> "" "Flat {Mergefield Flat}"}
{IF {Mergefiield Zip} <> "" "Zip {Mergefield Zip}"}

each placed where you want the information placed.
The fields type in the standing text and the field only when the fields have
content.

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


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