Hi pcor,
You can force the substitution of $0.00 for missing records via the following process:
1. Select your mergefield. For the purposes of this example, I'll suppose it's named 'Value' and shows up as '«Value»' in your
mailmerge main document.
2. Press Ctrl-F9 to embed your mergefield in another field, so that you get '{«Value»}'.
3. Type 'Set Val' into the '{«Value»}' field, so that you end up with '{Set Val «Value»}'
4. After the newly-inserted field, press Ctrl-F9 again to insert another (empty) field, so that you get '{Set Val «Value»}{ }'
5. Type '=Val \# "$,0.00"' into the second field, so that you end up with '{Set Val «Value»}{=Val \# "$,0.00"}'
6. Run your mailmerge.
--
Cheers
macropod
[MVP - Microsoft Word]
pcor said:
I now have a document that show a number of lines showing various amount
donated on certain dates. I have no trouble showing any amount that is on
the mailmerge document ..but how do I show $.00 if the entry is blank
Thanks for the help
