letter salutations and envl. address.

[hi]

I have a list of names w/addresses;
however some of my list has no individual name over
company name and address.

I want the salutation to read:
Dear Mr. Jones (or what ever name is there)
over the addresses with names.

I want the salutation to read:
Dear Friends
over the addresses without names.

On the envelopes, however, I want them printed as
they are listed:

HOW DO I PROGRAM THIS CAPABILITY?

 

[Dave Peterson]

I bet you can do it on the MSWord side (you are doing a mailmerge??).

But since I don't speak MSWord, I'd insert a helper column (say a new column A)
and use a formula:

=if(b2="","Friends",b2)

And drag down.

Then use that helper column in the mailmerge.

(You could even fill in blank cells with Friends if you want. Select that
column that contains the names,
Then Edit|Goto|Special|Blanks
type Friends
and hit ctrl-enter
and all those blanks will be filled.

You didn't ask, but here's a couple of links that might come in handy:

http://www.mvps.org/dmcritchie/excel/mailmerg.htm
http://www.mvps.org/word/FAQs/MailMerge

The first is from David McRitchie and the second is by Beth Melton and Dave
Rado.