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 / August 2004

Tip: Looking for answers? Try searching our database.

Single but Multiple records

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
LDanix - 07 Aug 2004 01:43 GMT
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.
>.

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.