Mail merge question with a twist

[Mark]

Someone please tell me if this is possible:

I have a Word doc that I need to populate an employee list into.
However, this doc will be opened by many dept managers and each
manager should only see the employees they manage in the list. What I
would like to do is use our intranet (from which the appropriate list
of employees can be generated) to open the doc, then send the list of
employees to the document. Kind of a reverse mail merge. Can this be
done? If not, what are some other options?

I converted the doc to an html page and was able to get the results I
wanted, but now I'm told that each manager needs to be able to save
the doc after adding their employees to it. Printing is not a
solution.

Thanks.

- Mark

 

[Cindy M -WordMVP-]

Hi Mark,

I think you'll need to ask this one in a VBA newsgroup. I can envision a
macro in the document named AutoOpen (or one in the template named
AutoNew) that will get the list, but that's about as far as I can help
you because you don't tell us
- in what data format the list is stored
- how you expect to match up the manager with the data for the
individualized list
- mention which version of Word is used

I have a Word doc that I need to populate an employee list into.
However, this doc will be opened by many dept managers and each
manager should only see the employees they manage in the list. What I
would like to do is use our intranet (from which the appropriate list
of employees can be generated) to open the doc, then send the list of
employees to the document. Kind of a reverse mail merge. Can this be
done? If not, what are some other options?

I converted the doc to an html page and was able to get the results I
wanted, but now I'm told that each manager needs to be able to save
the doc after adding their employees to it. Printing is not a
solution.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any follow question
or reply in the newsgroup and not by e-mail