Word Merge to Word Spreadsheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Betty - 07 Jul 2005 23:27 GMT

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?

Reply to this Message

Doug Robbins - 08 Jul 2005 05:21 GMT

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

Signature

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

>I have a VB program that merges SQL fields to Word documents. You can
>select
[quoted text clipped - 10 lines]
> merge
> or set the documents to only allow manual calculations?

Reply to this Message