Too many line continuations

**TonyforVBA** · 12-07-2010, 10:48 AM

This is probably somthing real simple but Im new to SQL.
I have a macro for distributing e-mails and for the body of the e-mail Im having trouble including as many lines as I would like I am useing the line break code below for each new line. At the moment this has been working fine, but on trying to included any further text after 22lines I am getting the 'Too many line continuations' error flag.

Is there maybe a paragrahing code or somthing that I should be useing instead of all these line breaks?

Cheers!

 & vbCrLf & _

**snb** · 12-07-2010, 11:25 AM

Did you try:

replace("text1~text2~text3~text4~text5~text6~text7~text8~text9~text10","~",vbLf)

**Swift4Play** · 12-07-2010, 11:26 AM

Not sure if this is exactly the same as i've had recently but what i did was

Example:

Instead of

MsgBox " Hello " & vbCrLf & _
             " I'm Using "& vbCrLf & _
             " Lots " & vbCrLf & _
             " Of " & vbCrLf & _
             " Lines"

Try

MsgBox " Hello " & vbCrLf & " I'm Using "& vbCrLf & " Lots " & vbCrLf & _
             " Of " & vbCrLf & " Lines"

I'm not expert but this worked for me with me 'Too Many Lines' lines issue
Hope it helps

Too many line continuations

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Too many line continuations

Re: Too many line continutations

Re: Too many line continutations

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions