A mail merge document working fine but some data not available and we use a
lookup table (Excel) to add the required fields. It has worked fine for
adding an email address and a job description based on the merged user name.
However trying to add another database lookup is causing a real headache!
Although the lookup is structured indentically to the first two, the merge
always stops with an error "Unable to insert data as the query result is
empty" - however when you click OK the correct data IS inserted into the
resulting letter! As these merges are unattended I need to sort this out...
I did first try a SET statement but that did'nt work, I think because there
were too many nested IF statements (about 40 nested) - what is the limit on
nested IF's in Word?
TIA
Graham