mailmerge from exce, group rows onto same document.

[Simon]

Hi,

I need to mailmerge from Excel. Currently the data is in row, however all
rows that contain the same address I need to print on the same word
document.

For example the source is as follows:

Street City Model Code
Main Street Birmingham B1 12345
Main Street Birmingham B1 12455
Main Street Birmingham B 1 12456
Bristol Road Bilston C1 12336
Pershore Road Cradley C1 12223
Portland Place Manchester C3 61233
Portland Place Manchester C4 61234



I therefore need to print 4 seperate documents as follows:

1) Main Street - Listing the 3 entrys.
2) Bristol Road - Listing the 1 entry
3) Pershore Road - Listing the 1 entry
4) Portland Place Listing the 2 entrys

How can this be acheived?

 

[Doug Robbins - Word MVP]

See the "Group Multiple items for a single condition" item on
fellow MVP
Cindy Meister's website at

http://homepage.swissonline.ch/cindymeister/mergfaq1.htm#DBPic


Or take a look at the following Knowledge Base Article

http://support.microsoft.com/default.aspx?scid=kb;en-us;211303


--
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