Grouped Mail Merge

[shearbec]

Hi,

I have an excel spreadsheet that i'm trying to mail merge with a form letter.

The spreadsheet is setup with a field called, "Location". There can be multiple records for that location.

I want the Form letter to be able to list all records for that location on 1 letter. When the location changes, start a new form letter.

Is this possible?

Thanks...Shearbec

 

[dawnd3]

There is no way to do this, UNLESS someone knows of a way with VBA code. You would probably have better luck setting this up in a database if it is something you are going to do on a regular basis. Good Luck! Dawn

http://www.calliopeconsulting.net

 

[xlhelp]

Hi!

You might want to take a look at

http://homepage.swissonline.net/cindymeister/mergfaq1.htm#ComplexMerg

HTH

Indu