HTML formatting a field value as currency in outlook email

Access 2010
outlook 2010
vba

Creating an email from access..

I need the following fields going into a email to be formatted a certain way.
both of these fields should be in Currency format   (including a $ sign)
 mybody = "Please Review the request and advise if you support.<br><br>"
      mybody = mybody & "Request #: " & price_escNum & " <br>" & _
"Opportunity Value: " & OPPORTUNITY_VALUE & "<br>" & _
    "Rolling 12 Sales: " & ROLLING_12_SALES & "<br><br>"

Is there a  way to do this ?

Thanks
fordraiders
LVL 3
FordraidersAsked:
Who is Participating?
 
Bill PrewCommented:
Have you tried using Format(, "Currency") in the Access VBA, like:

 mybody = mybody & "Request #: " & Format(price_escNum, "Currency") & " <br>" & _

Open in new window


»bp
0
 
FordraidersAuthor Commented:
Worked great...
Thanks !!
0
 
Bill PrewCommented:
Great, glad that helped.


»bp
0
 
FordraidersAuthor Commented:
Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.