-
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!
-
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.
-
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.