 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / May 2006Mail Merge Question
I am trying to perform a mail merge that will result in several thousand salary agreements. Each salary agreement will have a person's name, job and salary. The problem is that most people have several jobs hence they occupy several rows in the list. When I perform the mail merge people with more than one job appear os a separate letter. I am having difficulty figuring out how to combine each person's job onto one letter. This is what my list looks like Name...............Job..................Salary John Doe..........Teacher..........39,000 John Doe..........Coach...............2,000 Mary Smith.......Teacher............40,000 Mary Smith........Club Advisor......1,000 When I perform a typical mail merge separate letters are generated for each job because the mail merge sees each row as a separate record. I need to find a strategy to create one letter for each name with each job listed. Is there a mail-merge trick I can use to combine the jobs into a single letter? Word merge does not readily lend itself to this sort of task, but for an example of how it may be done, see : How to use mail merge to create a list sorted by category in Word 2002 - http://support.microsoft.com/?kbid=294686  Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > I am trying to perform a mail merge that will result in several > thousand salary agreements. Each salary agreement will have a person's [quoted text clipped - 21 lines] > > letter? You are trying to perform a "multiple items per condition (=key field)" mailmerge which Word does not really have the ability to do: See the "Group Multiple items for a single condition" item on fellow MVP Cindy Meister's website at http://homepage.swissonline.ch/cindymeister/mergfaq1.htm#DBPic Or take a look at the following Knowledge Base Article http://support.microsoft.com/default.aspx?scid=kb;en-us;211303 or at http://www.knowhow.com/Guides/CompoundMerges/CompoundMerge.htm SignatureHope 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 am trying to perform a mail merge that will result in several > thousand salary agreements. Each salary agreement will have a person's [quoted text clipped - 20 lines] > > letter? I am appreciative for the solutions listed. Howeverr, they may be beyond my skill set. If I added an employee ID field that listed the employee's first occurence as 1 and the 2nd, 3rd, 4th, occurence as X. Would that help? Of course the 2nd employee's ID would be 2 and their subsequent rows would also be X. Would this make it any simpler? Thanks. No. There is no simple way when using Word. It is however quite simple in Access if you are au-fait with report design. SignatureHope 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 am appreciative for the solutions listed. Howeverr, they may be > beyond my skill set. [quoted text clipped - 7 lines] > > Thanks. Where is the mail merge data coming from? The mail merge data is coming from an Excel file.
|
Reply to this Message |
 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.