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 question in Word 2002

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Cheryl - 13 Mar 2007 16:22 GMT
Hi, I'm trying to do a mail merge label so that all members of a specific
group get a label with their name on it, along with the names of the other
members of the group below it.  Something like this:

Don H.

Mary K.   Jane D.
Peter M.  Kelly B.

The next label would be:

Mary K.

Don H.  Jane D.
Peter M.  Kelly B.

There will be about 200 people total, divided up into 30 groups.  I've tried
sorting the database different ways, but I can't seem to get it right.  Any
help would be greatly appreciated.
Peter Jamieson - 13 Mar 2007 17:19 GMT
Which version of Word, where is your data stored, and how is it structured?

e.g. is your data source a table in a Word file, or what?

Do you have one row for each individual? How are you indicating to which
group each person belongs - do you have something like

Group,Person
Group1,Don H.
Group1,Mary K.

etc., or what?

Peter Jamieson
> Hi, I'm trying to do a mail merge label so that all members of a specific
> group get a label with their name on it, along with the names of the other
[quoted text clipped - 17 lines]
> Any
> help would be greatly appreciated.
Cheryl - 13 Mar 2007 20:47 GMT
I'm using Word 2002 and may data is stored as a .mdb data base file.  My
fields are First Name, Last Name and Group.  I originally had another field
named "Position" which was the position within the Group.  I was trying to
sort by Group and Position to rotate the names to the top center position in
the label.  I couldn't get that to work.

Thanks, Cheryl

> Which version of Word, where is your data stored, and how is it structured?
>
[quoted text clipped - 31 lines]
> > Any
> > help would be greatly appreciated.
Peter Jamieson - 13 Mar 2007 23:32 GMT
Yes, I donn't think it's a particularly simple problem to solve, partly
because Word doesn't do "one to many" solutions out of the box and I don't
think just sorting your records into a particular sequence is going to be
enough.

There may be a simpler way to do this, but I would aim to create a new data
source that had columns

topname, listofnames

This would have one record for each participant, and a list of names
(probably separated by spaces) for all the other participants in their
group, e.g.

topname, listofnames
Don H., Mary K. Jane D. Peter M.  Kelly B.
Mary K.,Don H. Jane D. Peter M. Kelly B.
and so on

Then you would use that as the data source for your label merge, simply
putting { MERGEFIELD topname } (i.e. <<topname>>) at the top of each label
and <<listofnames>> below. There might be a word wrapping problem but let's
ignore that for now.

The question is how to create that list, and that really depends on what you
can use. It's actually not very difficult using Access, but...are you using
Access, and can you use it to create new tables and queries (preferably
using SQL) ? Or are you using Word and the facilities for data entry built
into MailMerge?

Peter Jamieson
> I'm using Word 2002 and may data is stored as a .mdb data base file.  My
> fields are First Name, Last Name and Group.  I originally had another
[quoted text clipped - 44 lines]
>> > Any
>> > help would be greatly appreciated.

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.