Word Merge to Word Spreadsheet

[Betty]

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?

 

[Doug Robbins]

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