Email & Format
 

I have a macro set up to generate an email based on fields totals in a form.
The field [Sum Of TOTAL AMOUNT] is in Currency format in the table the form
is based on. How do I get it to show as currency when it generates the email?

DoCmd.SendObject acSendNoObject, , , "My Recipients", , , _
"WEF Reconcilement", "Please accept this as confirmation we are in
receipt of " & [Count Of RS - NRS - WO PLACEMENTS] & " accounts for a total
of " & [Sum Of TOTAL AMOUNT] & "."