Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
![]()
My Excel database has a list of personnel and the number of hours of FMLA
used each month. I want to create a monthly report that lists each name and the number of hours used by that person for the current month or quarter. I've tried Directory, but I guess I'm doing something wrong. When I merge it repeats the information I have typed in the body of my report and lists 1 name. Do I have to create the Directory on a blank page and then type the report? This report has to be done every month and twice at the end of each quarter so I want to be able to just change the month each time. Any help will be appreciated. |
#2
![]()
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
![]()
Sounds like you are probably 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/cindy...faq1.htm#DBPic Or take a look at the following Knowledge Base Article http://support.microsoft.com/default...b;en-us;211303 http://www.knowhow.com/Guides/Compou...poundMerge.htm -- 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 "eeloie" wrote in message ... My Excel database has a list of personnel and the number of hours of FMLA used each month. I want to create a monthly report that lists each name and the number of hours used by that person for the current month or quarter. I've tried Directory, but I guess I'm doing something wrong. When I merge it repeats the information I have typed in the body of my report and lists 1 name. Do I have to create the Directory on a blank page and then type the report? This report has to be done every month and twice at the end of each quarter so I want to be able to just change the month each time. Any help will be appreciated. |
Reply |
Thread Tools | |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I mail merge to EMAIL from MS Word AND add a pdf attachment | Mailmerge | |||
mail merging formatted content | Mailmerge | |||
Mail Merge with separate Source Header document | Mailmerge | |||
Mail Merge (Word 2002 SP3)- | Mailmerge | |||
Mail merge to append / create a document? | Mailmerge |