Emailing through Groupwise in Access

[henley12]

I am trying to send a formatted email from Access and I seem to have reached a limit of characters in my email. Does anyone know of such a limit? Here is the code I am using:

Private Sub ConfigureHyperlink()
Dim emailAddress As String
Dim subject As String
Dim body As String

Const CRLF = "%0A"

'emailAddress = "name of recipient"
subject = "Help Desk Alert!!"

body = "******* Call Alert!! *******" & CRLF & CRLF
body = body & "Call ID: " & Me![CallID] & CRLF
body = body & "Caller: " & Me![LName] & ", " & Me![FName] & CRLF
body = body & "Phone: " & Me![Phone] & CRLF
body = body & "Department: " & Me![Dept] & CRLF & CRLF
body = body & "Description: " & Me![Description] & CRLF

mailingLabel.HyperlinkAddress = FormatEmail(emailAddress, subject, body)

End Sub

 

[Remou]

I recall running into such problem and I think it was fixed by an Office Service Pack, but it was some time ago.