[brent]

I've got a form letter linked to an Access query in which there are multiple
records for each location the letter is to be sent. I need to include
multiple records of certain fields into a single letter based on location.
Can't seem to figure out how to format the letter to make this happen.

[Graham Mayor]

How to use mail merge to create a list sorted by category -
http://support.microsoft.com/?kbid=294686

Fellow MVP 'macropod' has posted a tutorial on this, with working field
codes and a sample Excel data source, at:
http://www.wopr.com/cgi-bin/w3t/show...?Number=731107


--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



Brent wrote:
I've got a form letter linked to an Access query in which there are
multiple records for each location the letter is to be sent. I need
to include multiple records of certain fields into a single letter
based on location. Can't seem to figure out how to format the letter
to make this happen.

[Doug Robbins - Word MVP]

Easier done with a Report in Access.

--
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

"Brent" wrote in message
...
I've got a form letter linked to an Access query in which there are
multiple
records for each location the letter is to be sent. I need to include
multiple records of certain fields into a single letter based on location.
Can't seem to figure out how to format the letter to make this happen.