I need to get currency symbol in visual force email template. I want it to be the currency the user is using. I check the docs here:


But don't see anything that will give to me.

Any tips?

  • Do you need it as a field formula? – Sergej Utko Dec 20 '12 at 12:26

I'm infering from your question that User is the recipient type on your email template. So, how about something utilizing Custom Labels and the ability to access them dynamically, e.g.:

<messaging:emailTemplate subject="Test" recipientType="User" relatedToType="Account">

<messaging:htmlEmailBody >

   <apex:variable var="isoCode" value="Currency{!recipient.CurrencyISOCode}"/>        
   <apex:variable var="currencySymbol" value="{!$Label[isoCode]}"/>

   Your balance is {!currencySymbol}200.00



Then you can create a Custom Label CurrencyUSD, CurrencyGBP etc. etc.

  • I don't know enough about it, so i've added it as a comment but I wondered if Translation Workbench might also provide some options too? – Phil Hawthorn Dec 20 '12 at 13:32
  • I think he needs an image, not a text – Sergej Utko Dec 20 '12 at 13:46
  • @mast0r - yeah, i noticed that in your answer...I couldn't see a reference to an image, but i did go out on an Xmas party last night so my eyesight is not at its best :) – Phil Hawthorn Dec 20 '12 at 13:52
  • 1
    For me the party is just tonight :) – Sergej Utko Dec 20 '12 at 13:54
  • @Phil Hawton first line is <messaging:emailTemplate subject="Daily Digest" recipientType="User" relatedToType="My_Custom_Object__c"> so yes. Howevere your idea gives me: Error: Invalid field CurrencyISOCode for SObject User – dublintech Dec 20 '12 at 13:57

For the visualforce page i would take this one:

<apex:image value="{!CASE(YourObject.CurrencyIsoCode,'EUR','/img/euro.gif',

Like Mohith say's, here is an example with static resource :)

<apex:image value="{!CASE(YourObject.CurrencyIsoCode,'EUR',URLFOR($Resource.MyRes,'img/eur.gif'),

And for the Image field this:

IMAGE(CASE({!YourObject.CurrencyIsoCode}, 'EUR', '/img/euro.gif', 
                                          'GBP', '/img/gbpfund.gif',
                                                 '/img/default.gif'), 'image_label')
  • 1
    You may like to show how you can use static resources in your answer :).These images can change in sfdc server without any notice :) – Mohith Shrivastava Dec 20 '12 at 13:11

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.