Skipping blank fields

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rebecca - 28 May 2005 00:36 GMT

I have an excel document with names and addresses that I use to mail letters
to people. Some of the address are incorrect so I blanked them out. Now I
want to merge but skip the names that have no address. Can you help?

Signature

Rebecca Wells

Reply to this Message

Graham Mayor - 28 May 2005 05:44 GMT

The simplest plan would be to copy the addresses to a second file and remove
completely the ones that are not correct.
Always attend to the data rather than try to cobble something together in
the merge.

Signature

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

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

> I have an excel document with names and addresses that I use to mail
> letters to people. Some of the address are incorrect so I blanked
> them out. Now I want to merge but skip the names that have no
> address. Can you help?

Reply to this Message

Rate this thread: