Hi
I have been using the CDO method to send emails to people using text templates and placeholders, which work really well.
What I'd like to do is determine at the time of sending the emails, which template to use. Currently the text template is written within the module itself.
Is it possible to use a textbox from the form that creates the recordset to set the Text Template
I have been using the CDO method to send emails to people using text templates and placeholders, which work really well.
What I'd like to do is determine at the time of sending the emails, which template to use. Currently the text template is written within the module itself.
Code:
Const ForReading = 1, ForWriting = 2, ForAppending = 8
Dim fso, f
Set fso = CreateObject("Scripting.FileSystemObject")
'Open the file for reading
Set f = fso.OpenTextFile("c:\AccessTextFiles\letterTest.txt", ForReading)
'The ReadAll method reads the entire file into the variable BodyText
BodyText = f.ReadAll
'Close the file
Is it possible to use a textbox from the form that creates the recordset to set the Text Template