I know someone who wants to produce letters by mailmerge and the tricky bit is each letter needs to contain a number of tables and the content of those tables will be extracted from a database.
The extract isn't a problem, but the Word template is.
We have several ideas so far:
1) put one humongous line in the extract for each 'table' in the output.
2) Make a field for each possible extracted record and set it up to not print the fields without data
3) merge into a table in the template document.
Anyone know a good tutorial on this sort of thing? Or have experience they can share?
The document will look a bit like this:
There could be from 1-6 lines in the bit in italics, and there are several other similar parts in the document they need to produce.
The extract isn't a problem, but the Word template is.
We have several ideas so far:
1) put one humongous line in the extract for each 'table' in the output.
2) Make a field for each possible extracted record and set it up to not print the fields without data
3) merge into a table in the template document.
Anyone know a good tutorial on this sort of thing? Or have experience they can share?
The document will look a bit like this:
Dear Mr X
We have tried to contact you:
1st Aug by email
20th Jul by phone
Please ring ASAP
There could be from 1-6 lines in the bit in italics, and there are several other similar parts in the document they need to produce.