Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / March 2007

Tip: Looking for answers? Try searching our database.

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

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
lady - 29 Mar 2007 21:04 GMT
I want to merge consecutive names on a lablel format and not have any repeats.
Anne Troy - 29 Mar 2007 21:57 GMT
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
****************************
>I want to merge consecutive names on a lablel format and not have any
>repeats.
Doug Robbins - Word MVP - 30 Mar 2007 05:47 GMT
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.

Signature

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

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

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.