While I'm sure you could fix this using some VBA, I don't have the necessary
code to hand. But there are other possible approaches if it's not too much
of a slog to go through deleting the unwanted addresses again, e.g.
1. if you're using Word 2002/2003/2007, re-open your mail merge main
document, make sure your data source is attached, and find the "Mail Merge
Recipients" dialog. In Word 2002/2003 you can either find the appropriate
pane in the Mail Merge Wizard or use e.g. View|Toolbars to enable the Mail
Merge toolbar and click the third button on that. That lets you select the
individual records you want to merge. Deselect the ones you don't want and
merge again (I'd test that a small number of deletions works OK before doing
the whole lot)
or
2. As long as your label layout was simple (e.g. some fields and perhaps
text, no images, you you can try the following in most versions of WOrd on
Windows.
a. save your Mail Merge Main Document
b. create a new Mail Merge Main Document. Make it a "Catalog" merge (Word
2000 and earlier) or "Directory" merge (Word 2002 and later).
c. select the same data source as you used before. (If you started from
Outlook, try to use the relevant Mail Merge... options in there to get to
this point)
d. Create a 1-row, 1-column table. Do not add anything outside the table
e. insert the fields you need to create your labels (possibly the same as
the fields you put in your original merge
f. Merge to a new document. This should contain a single table with one
column and one contact in each row.
g. Save that document.
h. Delete the cells containing the contacts you do not want (i.e. don't
just delete the data in those cells)
i. Add a single row at the top of the table and insert a column name, e.g.
"Contact"
j. Save and close that document. Let's call it Contacts.doc
k. Create a new label merge (or adapt your old one). Set the data source to
be Contacts.doc, and insert the single field "Contact" in your label layout,
and "propagate fields" (if this doesn't work, e.g. because you're using a
Tablet PC, you can try the macro code at
http://tips.pjmsn.me.uk/t0005.htm)
l. merge to a new document, check and print.
Peter Jamieson,
