Mailto line breaks (%0D%0A) disappearing.

BloodyBill

New Member
Joined
Oct 5, 2020
Messages
35
Office Version
  1. 365
Platform
  1. Windows
I'm using Excel to generate a HTML web page. I use Edge to view that page. The page has "Mailto" links that launch Outlook message windows when clicked. (Besides populating the address line and subject line) the Mailto link has code that generates 6 lines of body copy. The line breaks are coded in the Mailto link by using %0D%0A

When I enter the hyperlinks and test them, they work correctly (6 lines of body copy) in Excel. When I save the HTML page, the links also work well in Edge.

Example Outlook Body Section Generated by Mailto Link:
Body Copy Line 1:
Body Copy Line 2:
Body Copy Line 3:
Body Copy Line 4:
Body Copy Line 5:
Body Copy Line 6:

But minutes later, when I open the Excel document back up again, the %0D%0A codes have disappeared. When I click the links (in Excel), the 6 lines are "smooshed" together into one line.

Example Outlook Body Section Generated by Mailto Link:
Body Copy Line 1:Body Copy Line 2:Body Copy Line 3:Body Copy Line 4:Body Copy Line 5:Body Copy Line 6:

If I then save the Excel file, it publishes the lost line breaks to the HTML doc — meaning the problem copies over to the HTML document in Edge.

Any help?
Thanks, Bill
 

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

Forum statistics

Threads
1,223,229
Messages
6,170,881
Members
452,364
Latest member
springate

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top