Using Excel to send email

Joined
Feb 2, 2020
Messages
2
Reaction score
0
Points
1
Hello, this is my first post so please bear with me.
I am developing a simple Excel spreadsheet (Office 2011) and have mastered how to send emails.
The issue i have is, how do I input a line break in the body text?

I have tried %0A, %0D, =CHAR(13) but none of it works.

The body text is in a cell (wrapped text) saying, "Please contact your consultant as soon as possible. You will need to call 123456 to make an appointment. Ensure you bring your most recent prescription. Regards. Dr NO"

This all comes out in one line. I'd like to insert carriage returns (or new line) after each period (full stop).

I am losing what little hair I have on this.

Nelly
 

krs


Joined
Sep 16, 2008
Messages
3,555
Reaction score
610
Points
113
Location
Canada
Welcome to the forum.

I don't really understand what you mean by the part that you mastered, ie sending an email....

But to answer you question about a line break after each sentence, when you type the sentence, at the point where you want a line break or carriage return, try using
CONTROL-OPTION-RETURN

I just tried that in 2011 MS Excel and it does what I think you are after
 
OP
N
Joined
Feb 2, 2020
Messages
2
Reaction score
0
Points
1
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..... :)
 

Shop Amazon


Shop for your Apple, Mac, iPhone and other computer products on Amazon.
We are a participant in the Amazon Services LLC Associates Program, an affiliate program designed to provide a means for us to earn fees by linking to Amazon and affiliated sites.
Top