Forums
New posts
Articles
Product Reviews
Policies
FAQ
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Menu
Log in
Register
Install the app
Install
Forums
Apple Computing Products:
macOS - Apps and Programs
Using Excel to send email
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="NellyGrice" data-source="post: 1841727" data-attributes="member: 403887"><p>Thanks krs</p><p>I tried that and, as you say, the cell shows a return after each sentence.</p><p>The issue is, when I use the HYPERLINK function to send an email I get the following (where K12 has the message):</p><p></p><p>"Please contact your consultant as soon as possible.%0DYou will need to call 123456 to make an appointment. %0DEnsure you bring your most recent prescription. %0DRegards. %0DDr NO"</p><p>The carriage returns can be seen as %0D but they do not produce an actual carriage return in Mail.</p><p></p><p>I use the following;</p><p>=HYPERLINK("mailto:"&B7&"?subject="&$B$1&"&cc="&$B$2&"&body="&$K$12,"send email")</p><p></p><p>I'm going to have a lie down now..... <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite1" alt=":)" title="Smile :)" loading="lazy" data-shortname=":)" /></p></blockquote><p></p>
[QUOTE="NellyGrice, post: 1841727, member: 403887"] Thanks krs I tried that and, as you say, the cell shows a return after each sentence. The issue is, when I use the HYPERLINK function to send an email I get the following (where K12 has the message): "Please contact your consultant as soon as possible.%0DYou will need to call 123456 to make an appointment. %0DEnsure you bring your most recent prescription. %0DRegards. %0DDr NO" The carriage returns can be seen as %0D but they do not produce an actual carriage return in Mail. I use the following; =HYPERLINK("mailto:"&B7&"?subject="&$B$1&"&cc="&$B$2&"&body="&$K$12,"send email") I'm going to have a lie down now..... :) [/QUOTE]
Verification
Post reply
Forums
Apple Computing Products:
macOS - Apps and Programs
Using Excel to send email
Top