Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Kate Kate is offline
external usenet poster
 
Posts: 69
Default How to mail merge multiple rows into one document

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.

  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default How to mail merge multiple rows into one document

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.

Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Merge Word Table. Multiple Rows. Alvaro E. Gonzalez V. Mailmerge 1 May 29th 08 08:37 PM
MailMerge : 1 mail for multiple rows in excel. Santha Kumar Mailmerge 1 April 26th 07 01:44 PM
Mail Merge with multiple rows for each customer? Mary Beth McNabb Mailmerge 1 April 24th 07 03:39 PM
Mail Merge with Multiple Rows rodger Mailmerge 2 March 16th 07 12:04 PM
mail merging multiple columns with varying number of rows troll_mage Mailmerge 1 November 10th 05 06:42 PM


All times are GMT +1. The time now is 05:09 AM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"