• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

use Excel’s HYPERLINK() formula to generate a mailto hyperlink.

B

bold_9

New Member
Hallo everybody.

first of all thank you an Chandoo for such great site for excel.

I have read the artikel about birthday reminder where you can use HYPERLINK() formula to generate a mailto hyperlink and it was very helpful because due my work I need to work on Excel sheet without macros.

I have a 2 questions:

1. I cannot format the email body so I can have line between sentenses, for instance:


Hello,

(line break)

I wish you a very warm birthday!

(line break)

Best regards,

(line break)

Bold


2. If I have too long text in my email then it gives me back #VALUE! message.


So how can I solve this problems.

Thank you in advance.


Bold.


Link to birthday template:

http://chandoo.org/wp/2010/10/26/birthday-reminder-template/
 
Bold


Firstly, Welcome to the Chandoo.org forums.


Q1. You can use a Ctrl+J to insert a Carriage return as you enter the text

It will not show up but should get transferred with the text into Outlook


Q2. Don't have long text
 
You must log in or register to reply here.
Back
Top