Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Word Merge to Word Spreadsheet
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? |
#2
|
|||
|
|||
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? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Word2000 letterhead merge | Mailmerge | |||
Underscore (_) will not always display in RTF files (Word 2002). | Microsoft Word Help | |||
is word perfect compatible with office word? | Microsoft Word Help | |||
Continuous breaks convert to next page breaks | Microsoft Word Help | |||
How to change merge forms from Word Perfect to Microsoft Word | Microsoft Word Help |