6 total posts
Re:Mail Merge with Excel data source (just want to know...)
Re:Re:Mail Merge with Excel data source (just want to know...)
Re:Mail Merge with Excel data source
Does it help to put a space (maybe even preceded by a single quote, but I don't think it makes any difference) in the empty cells? A cell with a space is something else than a empty cell.
If so, you might be able to write a macro to convert all cells.
I'm not versed in mail-merge, but is it possible to use an if-function somewhere in the form,
Re:Re:Mail Merge with Excel data source
I only know about Office 97, but this might apply to Office XP as well.
Does the Excel spread sheet show a zero for the data? I've found that I can select cells, then go to the Tools menu, select Options, and on the View tab unselect "Zero values". The cell then shows a blank cell rather than a zero and the field in the form letter is then blank.
Mail Merge with Excel data source
As per the probs you specified, I feel you just have to fix the field string. I mean if suppose you are using a number field, in the first record it treat that column as number and if there is any apha-nuemeric data, it will ignore and display as zero. So make sure the field in which it shows zero is a alph. field and nuemeric. I hope if you put all the field as alpha i.e (insert a fake record of some characters in the first record it will treat all the fields as alphabetic and so it wont give u zero.
Do lemme know