View Single Post
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson
 
Posts: n/a
Default How do I make currency print correctly in merged document?

Try using Alt-F9 to display the field codes and changing

{ MERGEFIELD myfield \*mergeformat }

to

{ MERGEFIELD myfield \#"$ ,0.00" \*mergeformat }

Peter Jamieson

"Confedlady" wrote in message
...
I have my letter set up with merge files. My field in access is set as
currency and I have it entered as $ 65,890.00. When I merge the field
prints
as 65890. I know I need a switch, but I can't get it right. Please Help!
Thanks