|
-
Sep 21st, 2000, 06:01 PM
#1
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!
-
Sep 21st, 2000, 06:15 PM
#2
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.
-
Sep 21st, 2000, 06:23 PM
#3
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|