| Author |  Topic  |  | 
              
                | AlfredSenior Member
 
     
 
                USA1527 Posts
 | 
                    
                      |  Posted - 29 January 2003 :  13:00:26     
 |  
                      | Snitz vs. 3.4.03 Additional data field "M_JOIN"
 This field denotes users who also joined the club.
 
 I have added the new data field to register.asp as chkString(rsKey("M_JOIN"),"SQLString"), and added
 quote:which works fine and lets me know when someone joins.if strEmailVal = "1"  and rsKey("M_JOIN") = "YES" then
 strRecipients = "battlegroup@ggholiday.com"
 strsubject = "Membership Application"
 strMessage = strMessage & "Username: " & rsKey("M_Name") & vbNewLine
 strMessage = strMessage & "Email: " & rsKey("M_Email") & vbNewline
 strMessage = strMessage & "Country: " & rsKey("M_Country") & vbNewline
 strMessage = strMessage & "Email address verified." & vbNewline & vbNewline
 %>
 <!--#INCLUDE file="inc_mail.asp" -->
 <%
 end if
 
 
 
 I would now like trigger a mail to the new member, but instead of the message text it should mail an html page.
 
 quote:How does the red part have to look to do that?my_Conn.Execute (strSql),,adCmdText + adExecuteNoRecords
 
 Call DoCount
 
 if strEmailVal = "1"  and rsKey("M_JOIN") = "YES" then
 strRecipients = chkString(rsKey("M_EMAIL")
 strsubject = "Welcome to the Club!"
 strMessage = (an html  file)
 end if
 %>
 <!--#INCLUDE file="inc_mail.asp" -->
 <%
 
 
 |  
                      | Alfred
 The Battle Group
 CREDO
 
 |  | 
              
                | NikkolForum Moderator
 
      
 
                USA6907 Posts
 |  | 
              
                | AlfredSenior Member
 
     
 
                USA1527 Posts
 | 
                    
                      |  Posted - 29 January 2003 :  13:27:13     
 |  
                      | I see. Does it have to be written right in there, or can I refer to the page by link?
 
 And by "telling my mail component" (I use jmail) you mean in inc_mail.asp, where it says: objNewMail.body = strMessage?
 If so, how do I state that to replace "strMessage"?
 |  
                      | Alfred
 The Battle Group
 CREDO
 
 |  
                      |  |  | 
              
                | NikkolForum Moderator
 
      
 
                USA6907 Posts
 | 
                    
                      |  Posted - 29 January 2003 :  13:36:59   
 |  
                      | no, you have to actually write the html... like strMessage="<html><body>blah</body></html>" 
 you'll need to look up how to specify html with jmail.  you'll need to make that in inc_mail.asp.  the statement will be something like objNewMail.format = "html" ... but i don't know for sure on jmail.
 |  
                      | Nikkol ~ Help Us Help You | ReadMe | 3.4.03 fixes | security fixes ~
 |  
                      |  |  | 
              
                | AlfredSenior Member
 
     
 
                USA1527 Posts
 | 
                    
                      |  Posted - 29 January 2003 :  15:17:12     
 |  
                      | Nikkol, if I change inc_mail.asp from it's current configuration (which you say is text), will I not screw up all other mailings?
 |  
                      | Alfred
 The Battle Group
 CREDO
 
 |  
                      |  |  | 
              
                | NikkolForum Moderator
 
      
 
                USA6907 Posts
 |  | 
              
                | AlfredSenior Member
 
     
 
                USA1527 Posts
 | 
                    
                      |  Posted - 29 January 2003 :  16:40:18     
 |  
                      | I see, you mean it will be legible, and not like html code. That would be ok, wouldn't it?
 
 Now all I have to find out is how to configure that line in Jmail.
 Where would I find that?
 |  
                      | Alfred
 The Battle Group
 CREDO
 
 |  
                      |  |  | 
              
                | NikkolForum Moderator
 
      
 
                USA6907 Posts
 | 
                    
                      |  Posted - 29 January 2003 :  16:43:29   
 |  
                      | As long as the person receiving can accept html email.  If they cannot, they will see the html code.  Look up the command you need at jmails site. |  
                      | Nikkol ~ Help Us Help You | ReadMe | 3.4.03 fixes | security fixes ~
 |  
                      |  |  | 
              
                | AlfredSenior Member
 
     
 
                USA1527 Posts
 | 
                    
                      |  Posted - 29 January 2003 :  16:47:17     
 |  
                      | Ah well, that's ok then - if someone doesn't accept html mail he's probably used to that. 
 I'll go to see the Jmail people now - wish me luck.
 
 |  
                      | Alfred
 The Battle Group
 CREDO
 
 |  
                      |  |  | 
              
                |  |  Topic  |  |