Skipping blank fields

R

Rebecca

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?
 
G

Graham Mayor

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.

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


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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Insert name and adress from a list in a word document 1
Merging from an Excel file with graphics 1
Blank Page After Envelope-Label Wizard 5
Grouping Names in Mail Merge 0
Mail Merge Directory Conditional Page Break 0
Publisher is filling blank lines with data 2
Using SkipIf with date problem 1
VBA - exporting serial letters to single documents 0

Top