[EddieR]

I am using a Word document to mailmerge from an Excel 2007 spreadsheet

The Word document merges a single form and a covering letter per address

I do not know VBA or how to stop a blank cover letter being printed

What I need to do is print variable numbers of forms per address but only one covering letter per address

e.g.

formA 1
formA 2
cover letter A

form B 1
cover letter B

formC 1
formC 2
formC 3
cover letter C

A B C are unique addresses and 1 2 3 are also unique references

I am looking for a way to set a variable and check if the next record has the same reference if it does it prints another form

if it does not match a cover letter is printed and the variable set to the new reference and a form printed

1. declare variable
2. set variable to record and print form
3. compare variable to record 2 if matching print form 2
4. if not matching print cover letter
5. set variable for record as per 2 and loop until all records are printed

An alternative would be to check for a flag in the Excel record and only print a cover letter if the flag is set

Could anyone advise the code , code structure or a workable method to do this please?

[Lisa Wilke-Thissen]

Hi,

I am using a Word document to mailmerge
from an Excel 2007 spreadsheet

What I need to do is print variable numbers
of forms per address but only one covering
letter per address

Have a look at these articles:

"How to use mail merge to create a list sorted by category in Word"
http://support.microsoft.com/kb/294686

"Mail Merge 'Many-to-One' ..., "
http://www.gmayor.com/ManyToOne.htm

Or download:

"Using the Many to One Facility"
https://skydrive.live.com/?cid=5AEDC...615E886B%21566

--
Cheers,
Lisa

[EddieR]

Thank you will check them out

Eddie