Add Line Break

[bonnepoutine]

Hi guys,

I'm creating a template in excel to automate an e-mail that has to be sent out to different customers. I'm pretty much just using the ''&'' function to add individual information to generic text. What I would like to do is have it start off like this:

''Dear Mr. Brown,

Please find document 123 enclosed in.....bla bla.''

How can I insert a line break in my formula so that it can be copy/pasted into an e-mail in the same format ?

Thanks in advance !

 

[diddi]

line break is Chr(13) in vba

eg "Dear blah," & chr(13) & "hello"

 

[Ruddles]

<deleted>

 

[pgc01]

Hi

If diddi's solution doesn't work, try these ones (the most usual ones)

"Dear blah," & vbLf & "hello"

or

"Dear blah," & vbNewLine & "hello"