I have a VB program that merges SQL fields to Word documents. You can select
10+ documents to print at the same time.

I set up a Word Spreadsheet to take fields from SQL, merge into the
spreadsheet and sum columns.

Word normally works well merging 10 documents but adding math bombs the
merge. It appears that Word math is trying to calculate before Word merge
completes.

Is there a way to tell the document not to do the math until after the merge
or set the documents to only allow manual calculations?

Perhaps you could use VBA to lock the fields and then following the merge,
unlock them and update them.

--
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
"Betty" wrote in message
...
I have a VB program that merges SQL fields to Word documents. You can
select
10+ documents to print at the same time.

I set up a Word Spreadsheet to take fields from SQL, merge into the
spreadsheet and sum columns.

Word normally works well merging 10 documents but adding math bombs the
merge. It appears that Word math is trying to calculate before Word merge
completes.

Is there a way to tell the document not to do the math until after the
merge
or set the documents to only allow manual calculations?