Re: Display one to many records in a mail merge

You could either use this:
http://www.mvps.org/access/modules/mdl0004.htm

or better, there's code in Access Developer's Handbook Volume I that
does just this. The example in the book is an invoice, but the idea is
exactly the same. IIRC, they use automation, not a mailmerge. They
send the incident info as an ADO recordset and convert it to a
delimited text block and then convert that to a table.

the book may cost you $60, but if you're doing serious development,
it'll pay for itself very quickly.

.

Relevant Pages

  • Re: DELL goes down hill.
    ... PA Bear wrote: ... > Would you be willing to pay $100 or more for this? ... Why would it cost $100 more to supply a real CD over the different ... Prev by Date: ...
    (microsoft.public.windowsxp.general)
  • Re: Two for £1 each
    ... > So does two cost me £2 or £1 ... > (Sainsburys mince pies). ... the more you buy the less you pay. ... Prev by Date: ...
    (uk.legal)
  • Re: Heinrich requests to gargle with Prime Minister Sharons urine.
    ... this time make sure you pay for the cost of transportation ... Prev by Date: ...
    (soc.culture.israel)
  • Re: phone jacks
    ... >What does a crimping tool typically cost? ... ?I think one would probably pay for itself in a year or two. ... > Allan Adler ... Prev by Date: ...
    (sci.electronics.misc)
  • Re: Druid respect question.. respect
    ... As many times as you can pay for it. ... The cost eventually caps at 50g. ... Prev by Date: ...
    (alt.games.warcraft)