Results 1 to 3 of 3

Thread: How can I Import textfile into VB???

  1. #1
    Guest

    Question

    Hi.

    I am using the program which sends e-mail automatically through outlook. This data of address is connected to Access.

    What if I want to import existing textfile as a body message, how can i write VB script?
    Therefore, people who is not familier with VB also can modify or edit message.

    Please help me!
    Thank you!

  2. #2
    Guest
    Here's some code I've just used

    Open App.Path & "\ReminderLetter.html" For Binary As #1
    Put #1, , strHtml
    Close #1

    This opens "Reminder Letter.html" which is in the same folder as the App (App.Path)

    Put #1 then replaces the existing ReminderLetter

    I then added ReminderLetter.html as an attachment

    Hope it's useful.

  3. #3
    Guest
    Here's another idea!
    Instead of getting your text from a text file, create a memo feild in you Access Database and get the text from there. It is easier to maintain, quicker to access, quicker to programm since you are already accessing the BD, and it's less bug prone.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width