Ask Search:
Anthony SkinnerAnthony Skinner 
I am moving from another CRM to SF and have ~300 email templates that I created there. They are in HTML format in a CSV. Is it possible to upload them using mapping?
Best Answer chosen by Anthony Skinner
Raja Kumar PallepatiRaja Kumar Pallepati
yes, it is possible. Please refer to the article. (
Alison WilliamsAlison Williams 

I am trying to get a mass email sent out for one of our campaigns and even though I have made sure that the company email shows properly in all known email setting locations for setup (I searched email) I am unable to send mass emails from the campaign due to the error: "invalid email address: FromAddress"  I have attached a screenshot below of the error and all settings I can find.  I have full permissions as an administrator and still cannot seem to send from the send list email option.  I can create an email on the Activity tab, but really want to avoid having to add all 261 emails to this list and would prefer to just have to send it once.

Mass Email Attempt 1Mass Email Attempt 2Mass Email Attempt 3Email Settings 1Email Settings 2
Best Answer chosen by Alison Williams
Anel MalabananAnel Malabanan
Hi Allison,

Try to go to your Personal Settings:

1. Click your Avatar, then click on Settings.
2. Email > My Email Settings
3. Try to choose the Salesforce, rather than using Send Through ...

The cause of this error is because of the Salesforce Send Through, the Send Through email that is connected is different from the FROM address that you will use to send the email
Ginny RichhartGinny Richhart 
I have a workflow rule that sends an email to a contact record when a case reaches a specific status.  Is there any way to confirm an email was sent?
Best Answer chosen by Ginny Richhart
Raja Kumar PallepatiRaja Kumar Pallepati
yes, you can check the email logs to confirm the delivery of emails sent from salesforce. Refer to the link below.
Use Email Logs to Monitor Emails Sent from Salesforce (
Chris DuncombeChris Duncombe 
So I know we can use logic functions (or at least certain functions) in email templates.  I am using an HTML email template for the opportunity object.  Let's say I want to have different text displayed int eh template based on the Type field.  I can do this fairly easily and the below works perfectly
{!IF(ISPICKVAL(Opportunity.Type, "New Customer"), "This is my text for new customer", "This is my text for an existing customer")}

I have tested this and it works fine.  This also tells me functions work in email templates as I am using IF() and ISPICKVAL() with no issues.

I am running into an issue if in my conditional I want to show another opporuntity field in the text.  If i use a text field, this works fine, so the below works fine
{!IF(ISPICKVAL(Opportunity.Type, "New Customer"), "This is my text for new customer and the opportunity text field 1 equals " + MyTextField1__c, "This is my text for an existing customer and the opportunity text field 2 equals " + MyTextField2__c)}

This works great and it displays MyTextField1__c or MyTextField2__c just fine.  

The issue comes when I want to present a picklist field.  I would assume that using the TEXT() function would work for this, but it does not.

Both of the following DO NOT work 

Just using the picklist field like I would a text field
{!IF(ISPICKVAL(Opportunity.Type, "New Customer"), "This is my text for new customer and the opportunity picklist field 1 equals " + MyPicklistField1__c, "This is my text for an existing customer and the opportunity picklist field 2 equals " + MyPicklistField2__c)}

Using the TEXT() function as I would in any other formula
{!IF(ISPICKVAL(Opportunity.Type, "New Customer"), "This is my text for new customer and the opportunity picklist field 1 equals " + TEXT(MyPicklistField1__c), "This is my text for an existing customer and the opportunity picklist field 2 equals " + TEXT(MyPicklistField2__c))}

So I know I could likely create a custom formula field on the opportunity to convert the picklist value to text, and use that in my template, but that seems like a huge waste of time and custom field.  Is there a way to display a picklist field value within a conditional in an email template?

Am I missing something?
Best Answer chosen by Chris Duncombe
Mike ArthurMike Arthur
Hey Chris,

Here's something I found here -

"Here is the official word from SFDC support: "While formulas do sometimes work in templates we don't officially support them. We have no documentation on them we almost always recommend the customer uses a Visualforce template if they have this requirement. If they don't want to go that route they can always create a formula field on the object that does this, and just merge that into the email template. "

Custom field is likely quicker than VF template but could be a fun exercise :-)
Mindy NewtonMindy Newton 
With Summer 19 release over the weekend, now when users click on a contact's email address, outlook doesn't open. Works in Classic - not in Lightning.  Worked for us on Friday prior to the release.  Email to Salesforce is enabled.
Best Answer chosen by Mindy Newton
Pattie HeintzPattie Heintz
Hey Mindy, there is a new feature for personal email settings in Lightning.  In Lightning, click your Profile picture on the top right and select Settings.
Go to "My Email Settings" and there are two options now:
"When you click an email address to compose an email, which email editor do you want to use?"
You will want to change it to open with the Default Email Application instead of the Salesforce email composer.
User-added image

The issue is because salesforce released this setting and defaulted everyone to "Salesforce Email Composer".

As far as I know, they still have not provided an option for admins to change other users preferences en masse, however you and your users could change the setting over manually so they can at least get work done.
Bryan LandBryan Land 
Does anyone know how to handle this particular problem with Email-to-Case and Queue management?

My org has a variety of different email addresses used for Email-to-Case and customers or agents will sometimes forward an email chain with a case ref id to another queue email address. The intended outcome when this happens is to transfer the case into the new queue, but it stays in the old queue. Any ideas?
Best Answer chosen by Bryan Land
Tom HoffmanTom Hoffman
You can probably handle this using Process Builder on EmailMessage object. 

Does the original case remain owned by the Case Queue or is it transferred to an actual user.  If not, do you store the original queue name, email, anywhere on the case record? 

Lets assume you store 'Queue Email' in an email field on the Case Record. 

When a new EmailMessage is created, CaseID is null boolean false, Case.QueueEmail<>EmailMessage To Email, and To Email = one of your queue emails, then update the Case Owner/Queue to the be Queue related to the To Email.  

If this makes sense, let me know, can get more specific on the steps. 

Alex HorstAlex Horst 
Our org was just upgraded to Summer 19 and we have discovered a new feature that we're not sure we buy into yet. When clicking on an email address on a contact record or within an account, Salesforce is opening send email in the utility bar not outlook direct. I have rifled through the release notes but can't seem to find a solution to default the email back to Outlook. Any ideas?
Best Answer chosen by Alex Horst
Alex HorstAlex Horst
Turns out this was a Summer '19 enhancement that was brought to my attention from support. It is also not something that can be updated administratively so you have to direct all of your users to update if you don't want them using the send email through Salesforce.

To change/update, you may refer to the steps below:

- Login to Salesforce
- Click on your profile icon (located on the upper-right side) then click on Settings
- On the left pane, kindly follow this path: Email > My Email Settings
- At the bottom part of the page, you'll see this settings "When you click an email address to compose an email, which email editor do you want to use?"
- Select "Default Email Application"
- Click Save
Aleksandra RadovanovicAleksandra Radovanovic 
I created Classic email template and attached a file to it, but when I use template in Outlook outgoing email (through Lightning for Outlook plugin), they file ends up not being attached. I go to Lightning for Outlook side window, select Email template and click on the template I built. Email template is added without any issues, including letterhead photo, but the attachments are not added. I test it and sending email template with attachmennt is working from within Salesforce, but for some reason not when used through LFO. Is it possible to use email template with attachments in Lightning for Outlook for outgoing emails? Am I missing something here?
Best Answer chosen by Aleksandra Radovanovic
Aleksandra RadovanovicAleksandra Radovanovic

Since nobody here asnwered my question, I am posting the anwer I got from Salesforce. The template attachment cannot be uploaded into Outlook at the moment. One solution is to use a link to point to a file, instead of an actual file, as an alternative. You can create a public link in Lightning which acts like a delivery but doesn't have all of the options. Using enhanced emails will create public links for larger files. You can also use Content Delivery instead of attachments (the option I decided to use). 

Nikolai HvidNikolai Hvid 

I have this link, which I create from an email, where I encrypt the subscribers' emailaddress and paste it into the URL as encrypted.


I do it like this:

%%[SET @encryptedemail = EncryptSymmetric(emailaddr, "des;mode=ecb;padding=zeros", @null, "mypassword", @null, @null, @null, @null) ]%%


I set my URL in the HTML like this:


I get a link like this:



So now I have the email encrypted in the URL, and on the landingpage I want to read the email again. 

So on the landingpage I have this, where I first read the encypted email from the URL, and the decrypt it.


%%[ SET @encryptedemail = QueryParameter("email") 
SET @decryptedemail = DecryptSymmetric(@encryptedemail, "des;mode=ecb;padding=zeros", @null, "mypassword", @null, @null, @null, @null) ]%%

The decrypted mail is:

However, I keep getting "500 Internal server error" when I do it. No matter what syntax I've tried.

The only way I can make it work is if I paste the encrypted email directly into the script, then it works. And that's even though that the @encryptedemail is set to the exact same encrypted email when I display it.


This means that it works when I do this:

%%[ SET @encryptedemail = QueryParameter("email")
SET @decryptedemail = DecryptSymmetric('S8sdh+dSdSa=', "des;mode=ecb;padding=zeros", @null, "mypassword", @null, @null, @null, @null) ]%%

The decrypted mail is:


Am I missing something?

Best Answer chosen by Nikolai Hvid
Nikolai HvidNikolai Hvid



I did find a workaround that is simpler, however it only works when you're redirecting to a Salesforce Cloudpage.

So the way I did it was in the e-mail I created the link like this:

<a href="%%=RedirectTo(CloudPagesURL(1234))=%%" >CLICK HERE</a>
Replace 1234 with your Cloudpage ID. You find it in the options for the cloudpage, which you want to redirect to.


This way all the attributes of the recipient is sent hidden to the landingpage.

On the landingpage we can then fetch the e-mail address and any other attributes for the member like this:

VAR @country
SET @country= QueryParameter('country')
The country is:<br>

Email of the customer:<br>

And e-mail can be fetched with just %%emailaddr%% as I think that is a native attribute from Salesforce.


Denise CrosbyDenise Crosby 
I am trying to setup my users with Lightning For Outlook. We have Office 365 and Office Professional Plus 2013. We also have Salesforce Enterprise Edition. After installing the plugin here (, users cannot see the "View" button in Outlook to be able to sync emails to Salesforce. I was somehow able to get it working on my machine, so I know it should look like this:

User-added image
Best Answer chosen by Denise Crosby
Harold CarlsonHarold Carlson
Sorry, I looked all around my implementation and I cannot find a way to not make it show up.  I would open a case with Salesforce support.