I have a spreadsheet in Excel that contains my employees' data (name, ID,
manager, etc.) along with "coaching issues". Every item has its own column.
The majority of the time, a person will be listed several times with several
different coaching issues.
Is it possible for the Mailmerge to create one page that includes the
employee's data (one time) and all the records under his/her name (such as in
a table format); and do this for all employee's listed on the spreadsheet? I
am trying to get away from creating a page for every issue under the same
employee.
My idea is to create a small but comprehensive report that I may be able to
give each employee at the end of the month. One glance sees everything,
without having to flip from page to page for the same employee.
Peter Jamieson - 07 Aug 2004 10:53 GMT
Word isn't designed for this but see Cindy Meister's article at
http://homepage.swissonline.ch/cindymeister/
go to Mailmerge FAQ, Special merges, "multiple items per condition".
If you have Access, a better way to do this would probably be to store your
data in Access, or import it or link to it, and use Access reporting
instead. Logically, you would need to separate your data into two tables.
More up-front work though!

Signature
Peter Jamieson
> I have a spreadsheet in Excel that contains my employees' data (name, ID,
> manager, etc.) along with "coaching issues". Every item has its own column.
[quoted text clipped - 10 lines]
> give each employee at the end of the month. One glance sees everything,
> without having to flip from page to page for the same employee.
Doug Robbins - 07 Aug 2004 14:30 GMT
If you use a Catalog (or in Word XP and later, a Directory) type mailmerge
main document with the merge fields in the cells of a single row table in
the mailmerge main document with the "key" field in the first column, and
then you execute that merge to a new document and run the following macro on
that document, it will produce a result similar to that which you are after:
' Macro created by Doug Robbins to create multiple items per condition from
a directory type mailmerge
Dim source As Document, target As Document, scat As Range, tcat As Range
Dim data As Range, stab As Table, ttab As Table
Dim i As Long, j As Long, k As Long, n As Long
Set source = ActiveDocument
Set target = Documents.Add
Set stab = source.Tables(1)
k = stab.Columns.Count
Set ttab = target.Tables.Add(Range:=Selection.Range, numrows:=1,
numcolumns:=k - 1)
Set scat = stab.Cell(1, 1).Range
scat.End = scat.End - 1
ttab.Cell(1, 1).Range = scat
j = ttab.Rows.Count
For i = 1 To stab.Rows.Count
Set tcat = ttab.Cell(j, 1).Range
tcat.End = tcat.End - 1
Set scat = stab.Cell(i, 1).Range
scat.End = scat.End - 1
If scat <> tcat Then
ttab.Rows.Add
j = ttab.Rows.Count
ttab.Cell(j, 1).Range = scat
ttab.Rows.Add
For n = 2 To k
Set data = stab.Cell(i, n).Range
data.End = data.End - 1
ttab.Cell(ttab.Rows.Count, n - 1).Range = data
Next n
Else
ttab.Rows.Add
For n = 2 To k
Set data = stab.Cell(i, n).Range
data.End = data.End - 1
ttab.Cell(ttab.Rows.Count, n - 1).Range = data
Next n
End If
Next i

Signature
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.
Hope this helps,
Doug Robbins - Word MVP
>I have a spreadsheet in Excel that contains my employees' data (name, ID,
> manager, etc.) along with "coaching issues". Every item has its own
[quoted text clipped - 15 lines]
> give each employee at the end of the month. One glance sees everything,
> without having to flip from page to page for the same employee.
jacquieamer \(removethis\) @earthlink.net - 08 Aug 2004 06:43 GMT
In the spreadsheet list the employee data, but have
columns named "CoachingIssue1" "Coaching Issue2", etc.
>-----Original Message-----
>I have a spreadsheet in Excel that contains my employees' data (name, ID,
[quoted text clipped - 12 lines]
>without having to flip from page to page for the same employee.
>.