Hi,

I want to create and send emails to various people's details from a database and using different word templates based on the catergory of the people belong to. The word templates will have many variable to be inserted from the database. The code to generate will be asp cdo.

TIA
Tissa

You mean that you can send mail to different addresses which are in your database for getting their details and send mail to them


eg

<%
strSQL2 = "Select * from Contacts "
    set objRS2 = objDataConn.execute(strSQL2)
Set myMail=CreateObject("CDO.Message")
myMail.Subject=objRS2(Subject)
myMail.From="Your adress"
myMail.To=objRS2(address)
myMail.TextBody=objRS2(message)
myMail.Send
%>


Cheers :)




Love 4 all

Thanks for that qazi_nomi,

Actually I want to use a Word Template and the Database.
I have done emails with database parameters.
Now I need to use Word Templates...

Any help appreciated.

TIA
Tissa

The easiest method is to

1) convert the word template to html tremplate.

2) insert template variables into html file. You may define tags for this. For e.g. [currentdate] may be one variable. [bookingnumber] may be another variable.

3) read the template into a string.

4) Now, open database. Traverse through records.

5) For each contact, replace the template variables with appropriate values. The function Replace will be of help in this case.

6) You can set this string as the value of HTMLBody property of cdo object.

Please take care not to have the variables as part of the other content of template. The delimiters may be chosen appropriately.

If you want to send the word templates as a attachment then simply send

myMail.AddAttachment "c:\mydocuments\yourfile.doc"


Love 4 all

Hi Tissa,

Some minor changes I would add to the one suggested by Madhu.

1) convert the word template to html template. May be you can name it as template1.txt / template1.asp / template1.csv / template1.html itself

2) insert template variables into html file. You may define tags for this. For e.g. [currentdate] may be one variable. [bookingnumber] may be another variable.
You can as such use ASP variables instead of User defined TAGs.
Eg:
Dear <%=RsObject("FName")%> <%=RsObject("LName")%>,
            OR
Response.write "Dear " & RsObject("FName") & " " RsObject("LName") & ","

3) Read the template into a string. using FileSystemObject

4) Now, open database. Traverse through records. If needed, do a response.write of the string read from template, to see if data got substituted in relevant places.

You can avoid doing a replace mentioned in this step, as everything is in place after using ASP variables in the template.
5) For each contact, replace the template variables with appropriate values. The function Replace will be of help in this case.

6) You can set this string as the value of HTMLBody property of cdo object.

Everything else is the same.
Hope that helps.
Cheers!

_________________________
- Vijay G
Strive for Perfection

Helo Vijay,

Yes. This method is much more efficient that mine. This helps me also as I am doing a similar work now.

Thanks for madhugv and happygv for the excellant answers.

and happygv for giving the sample code bits.

Tissa