Discussions

Expand all | Collapse all

URL Email data all going to "To" suddenly

  • 1.  URL Email data all going to "To" suddenly

     
    Posted 08-25-2020 20:13
    Using a URL - Formula, as follows, this normally pre-populates an email with the form fields, but now it's including all details in the "To" field on the email rather than in the proper spots.  Any idea why?

    "mailto:" & [Customer Support Agent - Reviewer]&
    "&subject=" &"Review Request: "&[Adjustment Type] & " of " & [Credit Amount in USD] & " USD"&
    "&body="

    & "Hello," & "%0A%0A"

    & "I am requesting a " & [Adjustment Type] & " with the following details. Please reply with Posted in SAP OR Need More Info" &"%0A%0A"

    & "Please click here for more details: " & [Link to record] & "%0A%0A"

    & "Customer Error/Discretionary Credit" & "%0A"
    & "%20%20%20" & [Customer Error/Discretionary Credit?] & "%0A%0A"

    & "Sales Order Number: " & "%0A"
    & "%20%20%20" & [Sales Order (SO) number] & "%0A%0A"

    & "Original Order Amount in USD: " & "%0A"
    & "%20%20%20" & [Original Amount in USD] & "%0A%0A"

    & "Credit Amount in USD: " & "%0A"
    & "%20%20%20" & [Credit Amount in USD] & "%0A%0A"

    & "Sold To Name and Number: " & "%0A"
    & "%20%20%20" & [Sold To Name]& "%0A"
    & "%20%20%20" & [Sold To Number]& "%0A%0A"

    & "Original Invoice Date: " & "%0A"
    & "%20%20%20" & [Invoice Issue Date] & "%0A%0A"

    & "Here's why I'm requesting the " & [Adjustment Type] & ":"&"%0A%0A"
    & "%20%20%20" & [Reason for Credit/Debit or Rebill]

    ------------------------------
    Sheri W
    ------------------------------


  • 2.  RE: URL Email data all going to "To" suddenly

    Posted 08-25-2020 21:47
    try making a new field and try this formula.
    But I also had an experience where this syntax which has worked for me for the past 15 years suddenly stopped working for Microsoft Outlook. I never did figure it out. 

    "mailto:" & [Customer Support Agent - Reviewer]&

    "&subject=" &urlencode("Review Request: "&[Adjustment Type] & " of " & [Credit Amount in USD] & " USD") &
    "&body="

    & urlkencode("Hello,")
    & "%0A%0A"


    & urlencode("I am requesting a " & [Adjustment Type] & " with the following details. Please reply with Posted in SAP OR Need More Info")

    &"%0A%0A"


    & urlencode("Please click here for more details: " & [Link to record])
    & "%0A%0A"


    & urlencode("Customer Error/Discretionary Credit") & "%0A"
    & "%20%20%20" & urlencode([Customer Error/Discretionary Credit?]) & "%0A%0A"

    & "Sales Order Number: " & "%0A"
    & "%20%20%20" & [Sales Order (SO) number] & "%0A%0A"

    & "Original Order Amount in USD: " & "%0A"
    & "%20%20%20" & [Original Amount in USD] & "%0A%0A"

    & "Credit Amount in USD: " & "%0A"
    & "%20%20%20" & [Credit Amount in USD] & "%0A%0A"

    & "Sold To Name and Number: " & "%0A"
    & "%20%20%20" & urlencode([Sold To Name]) & "%0A"
    & "%20%20%20" & [Sold To Number]& "%0A%0A"

    & "Original Invoice Date: " & "%0A"
    & "%20%20%20"  &urlencode([Invoice Issue Date]) & "%0A%0A"

    & urlencode("Here's why I'm requesting the " & [Adjustment Type]) & ":"&"%0A%0A"
    & "%20%20%20"  & urlencode([Reason for Credit/Debit or Rebill])

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------