Mail megre Address Problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

tapnawk99@gmail.com - 05 Jul 2006 00:55 GMT

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

Reply to this Message

Graham Mayor - 05 Jul 2006 06:31 GMT

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.

Signature

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

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

> hi,
> i'm newbee on mailmerge function.
[quoted text clipped - 23 lines]
> tap
> thanks

Reply to this Message