mail merge: i want consecutive names to fall on each label set;

[lady]

I want to merge consecutive names on a lablel format and not have any repeats.

 

[Anne Troy]

Use mail merge. Be sure to follow ALL the steps:
http://www.officearticles.com/word/mail_merge_labels_in_microsoft_word.htm
If you still have difficulty, read this article, too:
http://www.officearticles.com/word/troubleshoot_mail_merge_results_in_microsoft_word.htm
****************************
Hope it helps!
Anne Troy
www.OfficeArticles.com
****************************

 

[Doug Robbins - Word MVP]

See the article "Mailmerge Labels with Word XP" on fellow MVP Graham Mayor's
website at

http://www.gmayor.com/mail_merge_labels_with_word_xp.htm

To remove duplicates, if your data source is a Word table, you will need to
sort the table (select Sort from the Tables menu) and then also on the site
to which I referred you above, you will find a method of dealing with
duplicates in the article about Finding and Replacing with Wildcards (Click
on the Up button on that site to see all of the article that Graham has
there).

If your data source is not in a Word table, you can get it into that format
by using a Directory type mail merge in the main document of which you
insert a one row table into the cells of which you insert the mergefields
from your data source. When you execute that merge to a new document, that
document will contain a table with a row of data for each record in the data
source. You can then insert a row at the top of that table into which you
enter the names of the mergefields. Save that document and use it as your
data source.


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP