Ok, I'm helping someone out with a mailmerge and there's something I can't figure out.
I've actually done a lot of mailmerges (on office 2000) but this one is odd.
Package: Word/Excel 2003
Problem:
This is the data:
http://img352.imageshack.us/img352/9162/exceloy0.jpg
This is what the document looks like, with the document merged to the data highlighted in blue above.
http://img155.imageshack.us/img155/921/mergednc7.jpg
As you see from the first picture, the overtime rate from the data is "n/a", but when it's merged to the document it comes through wrong.
Now I thought at first it might be Word not reading the text correctly (when it's expecting numbers), but if you look at the Shift Premium that has come through correctly - as well as the 2 boxes below it.
For completeness, here is the field codes used:
http://img530.imageshack.us/img530/947/unmergedbe4.jpg
Now as you can see, I have put field codes in that was copied directly from an MS website, to change the data - putting a pound sign in, only displaying a certain number of figures and putting 2 decimal points in.
I have tried removing those codes to see if that makes a difference - if I do that, the field reads "0" instead.
And just to confirm, if I merge the document with a line further up that actually has a number as the Overtime rate, it comes through correctly.
All of the cells are formatted as text, but I have tried to format it as currency, general, number and none of that makes a difference.
Bookmarks