Is it possible to override the field calculation errors?
I have tried a On error goto type command but it doesn't seem to detect the pop-up as an error.
Peter Jamieson wrote:
A few things you can try or look at... a.
08-Sep-08
A few things you can try or look at...
a. If you create a simple mail merge main document with no text, images,
etc, do you see the problem? Make sure the document is completely blank
other than the stuff you insert, i.e. no headers/footers etc. (A "bad"
normal.dot could be inserteing something unhelpful into every document you
create).
b. Do you actually have any calculation fields in the problem documents (
i.e. {=} fields ?)
c. Do you have numeric picture switches (e.g. \#$,0.00 ) in any of your
fields, and if so, do the characters for the decimal point and separator
match the ones in your Windows regional options?
--
Peter Jamieson
http://tips.pjmsn.me.uk
"dannyw" wrote in message
...
Previous Posts In This Thread:
On Wednesday, September 03, 2008 10:06 AM
danny wrote:
Error message when mail-merging from Excel 2003
I have always been able to mailmerge letters in Word using a data-source in
Excel but recently every time I try it I get an error message "A field
calculation error occurred in record 1" and I can then okay this and get the
same error message for record 2 and so on until the end of the data.
Annoying when I have ten or twenty records but when I have several thousand I
can't cope. This happens with different letters and different spreadsheets.
Any ideas?
--
Danny
On Monday, September 08, 2008 6:09 AM
Peter Jamieson wrote:
A few things you can try or look at... a.
A few things you can try or look at...
a. If you create a simple mail merge main document with no text, images,
etc, do you see the problem? Make sure the document is completely blank
other than the stuff you insert, i.e. no headers/footers etc. (A "bad"
normal.dot could be inserteing something unhelpful into every document you
create).
b. Do you actually have any calculation fields in the problem documents (
i.e. {=} fields ?)
c. Do you have numeric picture switches (e.g. \#$,0.00 ) in any of your
fields, and if so, do the characters for the decimal point and separator
match the ones in your Windows regional options?
--
Peter Jamieson
http://tips.pjmsn.me.uk
"dannyw" wrote in message
...
Submitted via EggHeadCafe - Software Developer Portal of Choice
Easy "NO SCRIPT" DataGrid Tooltips in ASP.NET
http://www.eggheadcafe.com/tutorials...--datagri.aspx