Expand all | Collapse all

Formula URL Character Cap

  • 1.  Formula URL Character Cap

    Posted 11-29-2017 14:23
    I am creating a Formula URL button that will automatically open and populate an email template through outlook.

    This is working perfectly until when I seem to enter a certain amount of characters, the button stops functioning. It does not give a warning or an error message - it is just lifeless upon clicking. 

    This is the formula below, I just replace 'Insert template here' with my template.

    This cap appears to be around 280 words or 1,400 characters.

    Is this something I can work around or will I have to break down these templates into smaller emails? 

    Thanks in advance for your help.


    "MailTo:" & URLEncode([Mentor])

    &"?cc=" & URLEncode([DSM])

    &"&subject= Welcome Mentor Template "&[Mentee] &" - Site #: "&URLEncode([Mentee])&" - Site Name: "&URLEncode([Mentee])

    &"&body=INSERT TEMPLATE HERE,"&"%0A%0A"&
    "From " & URLEncode([Mentee])

  • 2.  RE: Formula URL Character Cap

    Posted 11-29-2017 14:41
    The mailto protocol is considered old school and may in fact be deprecated or disabled by default for some browsers mail clients. However, some users still find it useful. There are limits on how long a URL can be that varies with browsers and versions. Much of the information you find on the internet concerning mailto could be stale. One resource says Outlook has a limit of 1840 characters. So if you want to use mailto you pretty much have to experiment with different browsers and mail clients and accept the results.

    That said if you are reaching the limit because of long recipient lists you could break this up into shorter recipient lists at the cost of manually sending more messages.

    If you are reaching the limit because of long body text you could arrange for script to copy text to the clipboard and have the user paste the clipboard into the body.

    Other possible solutions are to use some of the internal APIs QuickBase uses to send email under script control or to employ a proxy of some sort to send the email using a webservice or API.