Mailto in French not working

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

I suspect that this is a current shortcoming of QuickBase for Multi language support, but on a faint hope I am posting here.

I am using a MailTo command from QuickBase to populate the mail client with an email address, Subject and Body.  It works perfectly, in English.

But when the text includes French characters with accents 

I lose the Characters when they load to the email client.

Dear Mark
C�est juste apr�s la f�te de Pacques.

Nous �tions ferm�s Vendredi & Lundi.

C�est l�heure de diner bient�t.

�a c�est tr�s bien.


Any bright ideas out there?

Here is my current formula

"MailTo:" & URLEncode([Primary Contact email])

&"?subject=" & If(Trim([email Subject Line])="",URLEncode(" "), URLEncode([email Subject Line]))

&"&body=" & URLEncode([Note])

&"%0A%0A"

& URLEncode("Thank you")

&"%0A%0A"

& [Last Modified by First Name]

Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 69,572 Points 50k badge 2x thumb

Posted 3 years ago

  • 0
  • 1
Photo of David_In_Tucson

David_In_Tucson

  • 216 Points 100 badge 2x thumb
Hello Mark,

I had this come up recently as we are sending e-mails to French Canada.

Coding in the escape codes for the desired characters did the job.  It was a bit tedious, but it worked.


--> This is the reference guide I used: http://www.ascii.cl/htmlcodes.htm
Here are my notes from working with this (you may have other special characters) :

é    é    latin small letter e with acute

è    è     latin small letter e with grave

à   à   latin small letter a with grave

À    À   latin capital letter A with grave

ô    ô    latin small letter o with circumflex

ç    ç    latin small letter c with cedilla

’    ‘        left single quotation mark

–    –        en dash

«    «        left double angle quotes

»    »        right double angle quotes

û    û        latin small letter u with circumflex

’       curly apostrophe -->  ' (I just changed to the plain apostrophe that a generic text editor uses)


A friend said that it may be possible to add some code to the top of the HTML document, and this came up in conversation after I had hard-coded the escape characters.

I just looked at a web page we have in French Canada and found this:

<!DOCTYPE HTML>
<html lang="fr-CA">

<head>
If you have time to experiment with this it may be a more elegant approach than the brute force method I used.  Please let me (us) know what worked for you.


I trust this is useful.

- David in Tucson


(And, I'm glad to be able to help you especially after all the help you have given me over the years.)

Photo of David_In_Tucson

David_In_Tucson

  • 216 Points 100 badge 2x thumb
Apparently the e-mail client interprets things differently than a browser.  My e-mails looked great while I was making them, they only showed the  � characters in the actual e-mail.
- David
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 69,572 Points 50k badge 2x thumb
David, thx for responding!  I will try that on a small test to see what happens.  The email client in this use case is Outlook. Nothing ventured nothing gained, as they say.  I will post back .....
Photo of David_In_Tucson

David_In_Tucson

  • 216 Points 100 badge 2x thumb
Hi Mark, Did this help?

(The client I had trouble with was also Outlook -- web mail clients rendered fine.)

- David
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 69,572 Points 50k badge 2x thumb
Truthfully I did not test.  The data being transferred to the email was going to be user entered text, so figuring out how to parse out the special characters French characters and replace them was looking quite daunting.
Photo of David_In_Tucson

David_In_Tucson

  • 216 Points 100 badge 2x thumb
Yes,  parsing that would be tricky.

Perhaps this would work:
<!DOCTYPE HTML>
<html lang="fr-CA">
<head>

In the top of your e-mail?

- David