Mail Merge Word 2003

[Zonie32]

Hi all.

I am trying to mail merge from Excel 2003 to Word 2003.

I have a Company name field, say ABC Co. They have a list of Employees. I want to send the letter to the company and list the employee names somewhere in the body of the letter. However, I don't know how to make sure the Employees show up in the list on one letter for each Company.

How would I tell it to put this list of 5 employees with this company, then the next company has these 2 employees that should go on their letter?

 

[SkipVought]

Hi,

You can FILTER the source data in MS Word Mail Merge, prior to performing the merge to a new document.

Perform that process for each Company. x companies -- x merge documents.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[macropod]

Hi Zonie32,

What you're after is commonly called a directory or catalog merge. To see how to do this kind of mailmerge, check out my tutorial at:

http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Number=731107

Cheers

[MS MVP - Word]

 

[Zonie32]

macropod,

i could not open your merge document. it is blank.

 

[macropod]

Hi Zonie32,

Did you read the tutorial document? It explains how to use the accompanying mailmerge main document.

Cheers

[MS MVP - Word]