Creating HTML e-mail Distribution Lists from an Access Database

Discussion in 'Information Technology' started by Jim, Nov 11, 2005.


  1. Jim

    Jim Guest

    I maintain an Access database which includes e-mail addresses. I also
    maintain a Web page where I create various e-mail distribution lists using
    the HTML mailto: command. Is there an easy way to get my e-mail addresses
    from Access into a Web page with links that when clicked will open an e-mail
    addressed to the distribution list. There are 6 different distribution lists
    based on various queries from the database and maintaining each of them
    manually on the Web page using the mailto: command is a drag.
     
  2. Ron Hinds

    Ron Hinds Guest

    You don't mention what webserver you are using. If it's IIS then your answer
    is a simple ASP page, which might contain the following code snippet (assume
    a table named ContactInfo with at least two fields):

    <%
    oRS.Open "SELECT eMail, DisplayName FROM ContactInfo", oConn, adOpenStatic,
    adLockReadOnly

    Do Until oRS.EOF
    %>
    <A href="mailto:<%=oRS("eMail")%>"><%=oRS("DisplayName")</A><BR>
    <%
    oRS.MoveNext
    Loop
    %>

    You might want to check out this website for more info on using ASP:

    http://www.asp101.com


    "Jim" <Jim@discussions.microsoft.com> wrote in message
    news:D97EB140-B1DE-4EC4-B169-9F454488AD1E@microsoft.com...
    > I maintain an Access database which includes e-mail addresses. I also
    > maintain a Web page where I create various e-mail distribution lists using
    > the HTML mailto: command. Is there an easy way to get my e-mail addresses
    > from Access into a Web page with links that when clicked will open an

    e-mail
    > addressed to the distribution list. There are 6 different distribution

    lists
    > based on various queries from the database and maintaining each of them
    > manually on the Web page using the mailto: command is a drag.
     
Loading...

Share This Page