Do note that word will come up with a "blank" document if NO MERGE fields
are actual in the document.
(so, test, or try the merge with at least ONE actual merge field. This seems
to be a long standing word problem (but, why try and merge if there are no
actual data merge fields?).
It falls over if you use a Word "Fill-in" mergefield in the template.
Hum, I suspect the above is the first problem. You MUST have at least ONE
VALID data merge field in the document.
(that means at lest ONE field from the data file).
If you need a "prompt" type field, or a temporary field, do note that my
merge code DOES PICK UP UN-BOUND text boxes on the form.
So, you can use/have text boxes on your form, and they can be un-bound, and
they *should* appear in the merge.
Would be great if you could deal with this!
Many thanks
As mentioned, if you don't include any data merge fields, then the merge
fails, this is a word design issue. Feel free to double check the above,
but it is not a fill prompt field issue, but simply one of things NOT
working unless at least ONE data merge field is included in the document. As
far as I know, this problem been that way for the last 4 versions of word.
I am still struggling with getting some of my many fields
accessible as mergefields, despite all the advce and assistance you have
given re multiple tables.
As mentioned, you can override what fields are available and use a query (or
in-line sql) in place of the forms data source.
And, often, I create a query that is a "revere" join. In other words, if I
have one customer, and a sub-form with 20 invoice records. I might want to
merge to ONE of those 20 records, but include *some* fields from the "main"
record. So, in the query builder, in place of dropping in the main table,
and then the invoices table, I will do the reverse. (drop in the invoice
table, and then the main table. I then delete the join lines, and re-draw
them in the other direction -- this is very important). The resulting query
in this case means that I can send the ONE child record, but *easily*
include fields from the main record. So, the "trick" to include fields from
other records is to use a query, and NOT rely on the forms recordsouce for
the merge. however, I have *Cleary* stated, that you are SILL restricted to
merging ONE record to that word document, and if you need a "many" records
into ONE document, then my merge (which is a standard word merge) does not
accomplish this.
