Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
mailmerge from exce, group rows onto same document.
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? |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
mailmerge from exce, group rows onto same document.
See the "Group Multiple items for a single condition" item on
fellow MVP Cindy Meister's website at http://homepage.swissonline.ch/cindy...faq1.htm#DBPic Or take a look at the following Knowledge Base Article http://support.microsoft.com/default...b;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 "Simon" wrote in message news 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
mailmerge document | Mailmerge | |||
How to Close original Document after executing MailMerge. | Mailmerge | |||
Programmatically inserting mailmerge fields into a document | Mailmerge | |||
Protect mailmerge document | Mailmerge | |||
How to mailmerge formatted text from a Exel to Word document? | Mailmerge |