Mail Merge using Excel Input with sequence numbers 2

[Predator98]

I have a spreadsheet of demographic information for individuals and families. Each person's information is on a separate row. Each row contains a sequencing number. If it is a three member family (male spouse, female spouse, child) this would show as three separate rows but would have the same sequence number (ex. '1').

Using mail merge I would like to group all like sequence numbered data onto one page. Is this possible without having to create a macro?

If you don't think you can do somethin' it's purty near a cinch you ain't gonna!

 

[SkipVought]

Hi,

I don't think that Word is designed to do what you want.

Consider running from Excel, where you can turn on the AutoFilter and loop thru each of your indexes, filtering them one at a time, for instance.

Other more complex options are possible as well.

Skip,

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

 

[PeterMoran]

Hi,

It is definitely possible but not easy, as it requires quite some work in the coding associated with the MERGEFIELDS.

I used it to print invoices for customers where each line item was a merge record, so we only wanted to change page on a change of customer. I think this is similar to what you are wanting.

Try these pages:

http://support.microsoft.com/?kbid=105888

http://support.microsoft.com/support/word/usage/fields/default.asp

Also try;

http://homepage.swissonline.ch/cindymeister/MergFram.htm

and also

http://word.mvps.org/FAQs/MailMerge/index.htm

Good Luck!
Peter Moran

 

[macropod]

Hi Predator98,

What you're after is a Catalogue/Directory mailmerge:
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

There you'll find working examples.

Cheers


[MS MVP - Word]