mailmerge from exce, group rows onto same document.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Simon - 10 Jan 2007 13:32 GMT

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?

Reply to this Message

Doug Robbins - Word MVP - 10 Jan 2007 18:33 GMT

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

Signature

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

> Hi,
>
[quoted text clipped - 21 lines]
>
> How can this be acheived?

Reply to this Message