Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Problem with DTS and VB Email

Status
Not open for further replies.

lyric0n

Technical User
Dec 28, 2005
74
What I have is a DTS package set to run everynight, query a table, put the results into something called strRecord, then use the script below to email it.

Unfortunately, strRecord goes over 1024 characters (which it can do fine), the .HTMLBody ends up truncating it. How do I extend the length of .HTMLBody?

Dim oMsg
Set oMsg = CreateObject("CDO.Message")
With oMsg
.From = "lyric0n@yahoo.com"
.To = "lyric0n@yahoo.com"
.Subject = "Outdated Information"
.HTMLBody = strRecord
.Configuration.Fields(" = "smtp.server.com"
.Configuration.Fields(" = 2
.Configuration.Fields.Update
.Send
End With
Set oMsg = Nothing
end if
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top