Mailmerge location per page with multiple employees

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

bobh727 - 02 Feb 2006 03:32 GMT

I have a list in Excel of 150 or so employees working at 80 or so different
locations. The location data is duplicated for each employee at that
location.

I would like to use Mail Merge to print a page per location showing the
location name, address, phones, etc. followed by a table list of employees
(name, ssn, dob) at that location.

Each location has a unique 3 character alpha-numeric code.

I tried the approach in http://support.microsoft.com/?kbid=105888 and while
it makes sense, I'm having trouble adapting it to my situation.

Any suggestions or directions?

Reply to this Message

Graham Mayor - 02 Feb 2006 12:24 GMT

http://support.microsoft.com/?kbid=181730 may be nearer to what you want.

Signature

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

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> I have a list in Excel of 150 or so employees working at 80 or so
> different locations. The location data is duplicated for each
[quoted text clipped - 10 lines]
>
> Any suggestions or directions?

Reply to this Message