Sign Up |  Live StatsLive Stats    Articles 39,025| Comments 192,262| Members 20,148, Newest RupinderSingh23| Online 313
Home Contact
 (Forgotten?): 
    Sikhism
    For best SPN experience, use Firefox Internet Browser!


                                                                   Your Banner Here!    




Click Here to Register/Sign Up Daily Hukamnama Member Blogs Downloads Website Navigation Help Fonts Tags
Sikh Philosophy Network » Sikh Philosophy Network » Current News » Information Technology » Creating HTML e-mail Distribution Lists from an Access Database

Creating HTML e-mail Distribution Lists from an Access Database

Our Donation Goal : Why Donate? : Donate Today! : Donate Anonymously (ਗੁਪਤ) : Our Family of Supporters
Goal this month: 300 USD, Received: 50 USD (17%)
Please Donate...
       

Tags
creating, html, email, distribution, lists, access, database
Reply Post New Topic In This Forum Stay Connected to Sikhism, Click Here to Register Now!
  #1 (permalink)  
Old 11-Nov-2005, 18:09 PM
Jim's Avatar Jim
Guest
 
Posts: n/a
   
   
Creating HTML e-mail Distribution Lists from an Access Database

  Donate Today!   Email to Friend  Tell a Friend   Show Printable Version  Print   Contact sikhphilosophy.net Administraion for any Suggestions, Ideas, Feedback.  Feedback  

Register to Remove Advertisements
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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/7161-creating-html-e-mail-distribution-lists.html
from Access into a Web page with links that when clicked will open an e-mail
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7161
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.

*







Do you agree or disagree with the writer above? Why not share your immediate thoughts with us! Login Now! or Sign Up Today! to share your views... Gurfateh!
Reply With Quote
Sponsored Links
  #2 (permalink)  
Old 11-Nov-2005, 18:09 PM
Ron Hinds's Avatar Ron Hinds
Guest
 
Posts: n/a
   
   
Re: Creating HTML e-mail Distribution Lists from an Access Database

  Donate Today!  
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
%>
"><%=oRS("DisplayName")

<%
oRS.MoveNext
Loop
%>

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

http://www.asp101.com


"Jim" wrote in message
news97EB140-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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7161
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7161
> 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.



Reply With Quote
   Click Here to Donate Now!
Related Topics...
Thread Thread Starter Forum Replies Last Post
HTML Help in Access 2003 -- Help! Stacie Knobel Information Technology 0 28-Jul-2006 07:34 AM
Execute HTML Stored In Access Database mihir.kotwal@gmail.com Information Technology 0 28-Jul-2006 07:29 AM
MS Access using sharepoint lists Mr_leo Information Technology 2 28-Jul-2006 07:12 AM
Is there a template for Access 2000 that lists books? Emmint Information Technology 2 28-Jul-2006 07:02 AM
Creating database from DDL statements in an sql torch_music Information Technology 5 17-Nov-2005 16:02 PM


Support Us!
Become a Promoter!
Gurfateh ji, you can become a SPN Promoter by Donating as little as $10 each month. With limited resources & high operational costs, your donations make it possible for us to deliver a quality website and spread the teachings of the Sri Guru Granth Sahib Ji, to serve & uplift humanity. Every contribution counts. Donate Generously. Gurfateh!
ReplyPost New Topic In This Forum Stay Connected to Sikhism, Click Here to Register Now!

Bookmarks


(View-All Members who have read this thread : 0
There are no names to display.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are On
Pingbacks are On
Refbacks are On

» Active Discussions
Is Sikh Philosophy...
By eileen
Today 12:24 PM
4 Replies, 176 Views
Mitee Muslaman Kee
Today 08:50 AM
6 Replies, 193 Views
Fools Who Wrangle Over...
23-Oct-2014 08:27 AM
1,313 Replies, 154,977 Views
5 K's: Symbolic or...
By linzer
22-Oct-2014 23:38 PM
3 Replies, 135 Views
Freshness in mouth while...
22-Oct-2014 17:56 PM
9 Replies, 356 Views
09-11-2014
19-Oct-2014 23:02 PM
4 Replies, 1,767 Views
Waheguru Simran, Nitnem,...
19-Oct-2014 22:55 PM
82 Replies, 8,315 Views
Colour Red Gursikh...
11-Oct-2014 22:22 PM
13 Replies, 488 Views
Akal Takhat Jathedar...
10-Oct-2014 06:51 AM
8 Replies, 354 Views
GGS being burnt
09-Oct-2014 10:38 AM
58 Replies, 1,795 Views
Can we ever see Sri Guru...
09-Oct-2014 06:37 AM
67 Replies, 2,294 Views
Recreated Sikh regiment...
07-Oct-2014 10:54 AM
2 Replies, 325 Views
Deccani Sikhs: Punjabi...
02-Oct-2014 19:38 PM
0 Replies, 274 Views
Can I wear a Dumalla
By Akasha
02-Oct-2014 03:13 AM
12 Replies, 549 Views
Do you wear Kara?
30-Sep-2014 23:01 PM
5 Replies, 3,655 Views
» Books You Should Read...
Powered by vBadvanced CMPS v3.2.3
All times are GMT +5.5. The time now is 18:09 PM.
Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.
Search Engine Optimization by vBSEO 3.6.0 PL2 Copyright 2004-2015, All Rights Reserved. Sikh Philosophy Network


Page generated in 0.23856 seconds with 34 queries