Directory by department

O

OfficeNDN

Hello

I am trying to put together a directory using the mail merge and directory
tool in Word 2007. The list for the names would come from an excel
spreadsheet.

I would like to list employees by department. Rules would be used to list
employees of one department (for example, Education department) before going
to the next department.

I was think of something like "IF «Position_Title» EQUALS "Education" THEN"
and I am not sure what to put after that. Would it be "LIST"?

The formula could be listed each time with "Education" replaced with the new
department. The directory could just be updated in the excel spreadsheet
instead of having to type in a whole new directory each time someone gets
hired/leaves.

Also the departments have varying numbers of employees working in them so
rules would have to be made to include all of them.

I am very unaware of the rules/codes in word so if my example above is
nowhere close please forgive me.

Your help is greatly appreciated.
 
G

Graham Mayor

This is a lot more complicated to achieve than you might imagine - see How
to use mail merge to create a list sorted by category in Word 2002 -
http://support.microsoft.com/?kbid=294686
The principle remains true for Word 2007.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top