See the following page of fellow MVP Graham Mayors website:
http://www.gmayor.com/ManyToOne.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, originally posted via msnews.microsoft.com
"Kate" wrote in message
...
Hi,
I have a worksheet that lists subscribers of a service. It looks something
like this:
Organization Name Title Email
ACME CO. Smith, Sam CEO
ACME CO. Jones, Bill Staff
Each organization has one president and multiple staff members listed
(between 1 and 5 staff members). I want to email each president, through
mail
merge, and give them a list of all the current subscribers from their
organization (data from other rows in the worksheet).
Is this possible to do (using Office 2003)? Any insight is greatly
appreciated.
Thanks.