Merge - not wanting data to print

[erussell]

Greetings,

Not sure how best to explain it but here goes.

I have a database in Excel. I have three lines of address,
one is the street address, one is the mail address, third
is the town. For example street address might be 13
Whatever Street, sometimes with a RD1 (rural delivery
number) after it. The mail address could be a PO Box
number.

Some people/groups have data in each column.

Obviously letters should go to the mail address, but when
this is the same as the street address, I don't want it
looking like this:

Mr Joe Bloggs
Whatever Group
13 Whatever Street
PO Box 123
WHEREVER

What is the formula I should put in the base letter please?


Thanks

Jacqui

 

[Debra Dalgleish]

Are you merging the letters in Word? If so, you could use an
If...Then...Else to show or hide the duplicate address. For example:

IF {MERGEFIELD MailAddress} = {MERGEFIELD StreetAddress} "" {MERGEFIELD
StreetAddress}

There are instructions for using IF on the Word MVP site:

http://word.mvps.org/FAQs/MailMerge/MMergeIfFields.htm

Or, in Excel, you could create a new field, using an IF formula, and
refer to that field in the merge. For example:

=IF(D2=E2,"",D2)

 

[Guest]

Thanks Debra

-----Original Message-----
Are you merging the letters in Word? If so, you could use an
If...Then...Else to show or hide the duplicate address. For example:

IF {MERGEFIELD MailAddress} = {MERGEFIELD StreetAddress} "" {MERGEFIELD
StreetAddress}

There are instructions for using IF on the Word MVP site:

http://word.mvps.org/FAQs/MailMerge/MMergeIfFields.htm

Or, in Excel, you could create a new field, using an IF formula, and
refer to that field in the merge. For example:

=IF(D2=E2,"",D2)




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

.