Rich Text Character Limit in Outlook Email

[Dzine2009]

Is there a character limit for sending an rich text email through outlook using VB? If there is, is there another format that would allow me to add more characters?

 

[Dzine2009]

Maybe I need to be more specific because I have been searching but still have not found an answer to my problem.

I am writing my code in the Visual Basic Editor that comes with Access. My code sends an email through a command button. The code is working. In the .Body line as I am writing the text for the email the line stops when the VB Editor comes to the end of the scroll bar at the bottom at the word should.

The line looks like this

.Body = "Thank you " & Format(DLookup("Contact_Information_FirstName", "requests", "[Contact_Information_FirstName]=" & Chr(34) & Me!Contact_Information_FirstName & Chr(34)), " ") & " " & Format(DLookup("Contact_Information_LastName", "requests", "[Contact_Information_LastName]=" & Chr(34) & Me!Contact_Information_LastName & Chr(34)), "") & " for choosing Winding River Home Inspections. We are looking forward to assisting you in this exciting time." & vbCrLf & vbCrLf & "Your inspection has been scheduled and comfirmed for " & Format(DLookup("InspectionDate", "Inspection", "[InspectionID]=" & Me!InspectionID), "mmmm d, yyyy") & " at " & Format(DLookup("InspectionTime", "Inspection", "[InspectionID]=" & Me!InspectionID), " hh:mm AMPM ") & "at the following address; " & Nz(DLookup("SiteAddress", "Inspection", "[SiteAddress]=" & Chr(34) & Me!SiteAddress & Chr(34)), "") & "." & vbCrLf & vbCrLf & "To help you get the most benefit from the inspection you should

Questions

1. is there a line wrap option?
2. Is this a character limit issue?
3. is there a way to continue the text?
4. Is there a peice of code I should be using to tell VB to keep writing text after the linebreak in the code?

This is the final step in my project and I just cant seem to find anything. Would it help if I switched to HTML format in the Body format?

Any hint of a direction would be very helpful...

 

[Dzine2009]

Bumping. Anyone? If no one knows thats ok. This place has been very helpful.

 

[Dzine2009]

For now I am circumventing this issue by adding a signature with the rest of the straight text.

 

[darbid]

1. is there a line wrap option?
2. Is this a character limit issue?
3. is there a way to continue the text?
4. Is there a peice of code I should be using to tell VB to keep writing text after the linebreak in the code?

This is the final step in my project and I just cant seem to find anything. Would it help if I switched to HTML format in the Body format?

Any hint of a direction would be very helpful...

I think you mean in the VB editor is there a line wrap option and not in you email body. If I am right then you use a "_" to wrap in the editor.

I have not come accross a limit on the number of characters for an email. I also cannot see that the bodyformat would have anything to do with it.

 

[Dzine2009]

THANK YOU THANK YOU THANK YOU!!! This is exactly what I was looking for! I finished my project this morning and it is working flawlessly! I cant thank this board enough.