Problems with getting file text stream

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Stefan Dase

    #1

    Problems with getting file text stream

    Hello everybody!

    I'm not very experienced in ASP but have to extend a colleague's site.

    One page enables users to add new action-items to our database. After
    inserting the record it have to send an email to the responsible worker
    with title and description.

    I tried to read the message body from a template text file (*.htm) and
    substitute placeholders with the new data. But I only get an empty
    message body. Here is the relevant part of ASP code:

    'get email message from template
    sTmplt = Server.MapPath( "../templates/actionitem_emai l.htm")
    Set objFSO = Server.CreateOb ject("Scripting .FileSystemObje ct")
    If objFSO.FileExis ts(sTmplt) Then
    sMgs = objFSO.OpenText File(sTmplt).Re adAll
    Else
    sMsg = "File not found: " & sTmplt
    End If

    vEmail = rstRecipient.Fi elds(0).Value
    If Not IsNull(vEmail) Then
    With objMail
    .From = "bedabal@luerss en.de"
    .Subject = "Neue Aufgabe in BeDaBaL für Projekt " & sProjectName
    .To = vEmail
    .TextBody = sMsg
    .Send
    End With
    End If

    If i fill sMsg manually with some characters they appear in the email.
    But if I try to read out the template there is no text, even the Else
    branch isn't used.

    Do anybody has any idea?

    Many thanks,
    Stefan
  • Stefan Dase

    #2
    Re: Problems with getting file text stream

    Ups,

    sometimes it is very helpfull to have a little break. It was just the
    wrong notation:
    If objFSO.FileExis ts(sTmplt) Then
    sMgs = objFSO.OpenText File(sTmplt).Re adAll
    ^
    Else
    sMsg = "File not found: " & sTmplt
    End If
    Thank you,
    Stefan

    Comment

    Working...