| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Skipping blank fields
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? -- Rebecca Wells |
|
#2
|
|||
|
|||
|
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 My web site www.gmayor.com Word MVP web site http://word.mvps.org Rebecca wrote: 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 |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Blank return for drop-down form fields | Microsoft Word Help | |||
| How do I print blank lines in WORD 2002 when data fields are empty | Mailmerge | |||
| How do I prevent non-breaking spaces or blank fields during a Mer. | Mailmerge | |||
| How do I remove or supress blank data in fields in mail merge e.g. | Mailmerge | |||
| Blank fields when mail merging | Mailmerge | |||
Linear Mode
