Dismiss Notice
► Join Elite Columnists/Writer's Panel: You are cordially invited to join (register here) SPN's elite panel of Columnists, writers & start sharing your perspectives with a worldwide audience!

Creating HTML e-mail Distribution Lists from an Access Database

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

  1. Jim

    Jim
    Expand Collapse
    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. Loading...

    Similar Threads Forum Date
    Canada Ottawa weighs creating ambassador for religious freedom Current News Oct 4, 2011
    India SGPC Accused of Creating a Row Current News Jan 20, 2011
    Pacific International Gathering of Young Sikhs Focuses on Creating Good Citizens Current News Jan 8, 2011
    Are We Creating New Devtas? Sikh Sikhi Sikhism Aug 21, 2009
    Sikh News Sharif warns against creating instability in Punjab (Express India) Current News Sep 19, 2008

  3. Ron Hinds

    Ron Hinds
    Expand Collapse
    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