1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.
  2. Dear Guest, we truly appreciate your patience while we are working hard on the upgrade process, which was forced upon us due to the decline of our original forum software. Good news is SPN is almost ready to resume its normal operations soon. The new cutting edge software has been chosen with a primary focus on enhancing user experience especially while using SPN on the mobile devices such as tablets or phones. This new platform will also provide us the opportunity to implement new ideas which were not possible in old software. Forum appearance will be an on going process and you would notice significant changes as we mature working in the new software environment. Some of the core functionality like the blogs will be restored gradually. Once, the forum is fully active, please take your time navigating around the new forum functionality. We will also introduce you to new functionality from time to time.

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.
     

Share This Page