emailing newsletter from XML recipient list

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • slinky

    emailing newsletter from XML recipient list

    Thanks in advance for for any clues: I have a website I'm building
    using MS-Visual Web Developer Express (Asp.Net/VB.net). I'm tooling
    it
    to collect names and emails to send out our newsletter. I have
    successfully setup an XML file with some sample names and emails. I
    populated this through a well functioning .aspx page that writes to
    the XML file and I have set up another .aspx page from which I can
    view the collected persons. what I need is a way to send our
    newsletter (which for the time being will be just some text in the
    email body (but I'd like to do more). So I need to parse through the
    XML list and send an email to each recipient. Any clues?

    Here's my code for users entering their names and email addresses:


    <script runat="server">
    Private Sub Page_Load(ByVal sender As System.Object, _
    ByVal e As System.EventArg s) Handles MyBase.Load
    If Not IsPostBack Then
    Using ds As New DataSet()
    ds.ReadXml(Serv er.MapPath("ema ilList.xml"))
    txtNewEvent.Dat aBind()
    txtDate.DataBin d()
    End Using
    End If
    End Sub


    Private Sub btnSubmit_Click (ByVal sender As System.Object, _
    ByVal e As System.EventArg s) Handles btnSubmit.Click
    Using ds As New DataSet()
    ds.ReadXml(Serv er.MapPath("ema ilList.xml"))
    Dim dr As DataRow = ds.Tables(0).Ne wRow()
    dr("emailAddres s") = txtNewEvent.Tex t
    dr("name") = txtDate.Text
    ds.Tables(0).Ro ws.Add(dr)
    ds.WriteXml(Ser ver.MapPath("em ailList.xml"))
    End Using
    End Sub
    </script>


    Here's my code for viewing the list of emails:


    <script runat="server">
    Private Function MakeDataView() as DataView
    Dim myDataSet As New DataSet()
    myDataSet.ReadX ml(Server.MapPa th("emailList.x ml"))
    Dim view As DataView = New DataView(myData Set.Tables(0))
    view.AllowDelet e = False
    view.AllowEdit = False
    view.AllowNew = False
    view.Sort = "Name ASC"
    Return view
    End Function


    Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs)
    Dim view as DataView = MakeDataView()
    dgEmail.DataSou rce = view
    dgEmail.AllowSo rting = True
    dgEmail.DataBin d()
    End Sub
    </script>


    Thanks!!!

  • siccolo

    #2
    Re: emailing newsletter from XML recipient list

    hmm...you can use SQL Server to retrieve data from XML file and send
    emails...


    Comment

    • slinky

      #3
      Re: emailing newsletter from XML recipient list

      Ooops... my web hosting provider does not support SQLServer and I've
      had a dickens of a time installing it and finding workarounds. I have
      an Access database running on my site... can that be used to retrieve
      XML data? I'm a newbie to sending out bulk emails through VB.net/
      ASP.net so I don't know where to start.

      I did find this block of code that I may be able to learn something:

      <%@ Page Explicit="True" Language="VB" Debug="True" %>
      <html>
      <body>
      <%
      Dim EMailFrom As String = "bill@edgequest .com"
      Dim EMailTo As String = "billhatfield@e dgequest.com"
      Dim EMailSubject As String = "Important message!"
      Dim EMailBody As String = "Thanks for reading this" & _
      "message but I must admit, I lied. There's " & _
      "nothing important about this message at all."

      Dim MySmtpClient As New _
      System.Net.Mail .SmtpClient("lo calhost")

      MySmtpClient.Se nd(EMailFrom, EMailTo, _
      EMailSubject, EMailBody)
      %>
      </body>
      </html>



      On Feb 14, 8:31 am, siccolo <aleks...@hotma il.comwrote:
      hmm...you can use SQL Server to retrieve data from XML file and send
      emails...

      Comment

      Working...