Skip to main content
Question

Create email button on the form that contains long body text

I want to create a email button on the form to open outloook and send directly to the customer. I use formula URL below

"mailto:"&""&[PR - CR - Email]&"\n"&"?subject="&"\n"&URLEncode([subject1_Warranty Determination]) &""&"&body="&""&([Email body])&"&"


The field [Email body] is a formula text. It works fine if the email body [Email body] is short, which means that I click a button, an outlook window opens up. However, I add a long body text, nothing has came up. Can anyone please advice on how to create a button email that can have a long body formatted text?

Thank you!
    This topic has been closed for replies.

    You are creating a URL and URL may not have spaces or special charaters in them, so you need to URLEncode the body too

    "mailto:" & [PR - CR - Email]
    & "?subject=" & URLEncode([subject1_Warranty Determination])
    & "&body="    & URLEncode([Email body])



    For a single email notification type the from email address can be from the person who last modified the record. The person who last modified the record will be the person in your company who push the button to trigger the email getting sent. The advantage of that of course is that your client can respond to the email in a normal fashion and your employee will get the email.

    As for not wanting the employee to modify the template, well if you give them a form to send the customer and you don�t give your inside Staff and fields to fill out then it will be a standard template

    As for getting HTML text into an email notification, you can configure the standard email notification to send an HTML page. There are many free websites available where you can type in Rich a text and it will convert that Rich text into HTML. Then you simply copy and paste that HTML into your email notification.
    • SalesInfo
    • Author
    • Registered
    • January 8, 2019
    QuickBaseCoach App Dev./Training, 

    I am considering the notification option now. Can you please guide me on how to set it up and create an email button?

    Here is some help text on how to set up an email notification

    https://help.quickbase.com/user-assis...

    You can also set up a date time field called date email sent

    You can then trigger of the email notification to Fire when the checkbook�s field is checked and you can also set up a form rule that when the record is saved and the checkbox field has changed to change the date email sent Peel to the current date and time.

    When I get a chance I will post back with the formula to create a button that will check that check box and also set the email sent daytime field to the current date and time. Meanwhile you could get the email notification built.

    Post back when you get that working and that will be a reminder for me to post the formula.
    EverettPatterso
    Forum|alt.badge.img+10
    To answer your original question, I believe you are reaching the maximum character limit for the mailto: command via Outlook.

    Try using the email notifications as Mark suggested, copy the Send test email URL path and put that into a formula URL for your users to use as a button
    Terms & ConditionsAccessibility statement