View Single Post
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Single but Multiple records

See fellow MVP Macropod's "Word 97-2007 Catalogue/Directory Mailmerge
Tutorial" at:
http://www.wopr.com/index.php?showtopic=731107
or
http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip
Do read the tutorial before trying to use the mailmerge document included
with it as you must get the mail merge main document set up exactly as
required.


--
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, originally posted via msnews.microsoft.com
"maria" wrote in message
...
Hi jacqui! Did you solve your issue? I have the same question as you.
Would
be possible with this Macro??
Thanks!!
--
mery


"jacquieamer (removethis) @earthlink.net" wrote:

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,
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.
.