Lifting Email Addresses from Access
Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=8328
Printed Date: 30 March 2026 at 7:27am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Lifting Email Addresses from Access
Posted By: greytricky
Subject: Lifting Email Addresses from Access
Date Posted: 25 December 2003 at 11:56am
|
I use Access for my database with the web wiz forum and was wondering if there is an application (or a simple way) to lift/collect all the email addresses from the database and have them put into some sort of a text document ready for a mass email. i know web wiz does mass emailing from the admin side and i use this regularly BUT i wish to send my personalised newsletters from Outlook instead. Thanks in advance to the clever people who can assist me, cheers |
Replies:
Posted By: fernan82
Date Posted: 27 December 2003 at 12:01am
|
Read on the http://www.w3schools.com/asp/asp_ref_filesystem.asp - FileSystemObject and http://www.w3schools.com/ado/ado_ref_stream.asp - Stream Object , either one can write to a text file, just loop thru the recordset and write all the addresses to a file.... ------------- FeRnAN http://www.danasoft.com/"> 
|
Posted By: greytricky
Date Posted: 27 December 2003 at 7:28am
|
Hi fernan82, thanks for your reply but im not as technically trained as id like to be, i checked out those links and they were way above my head. Thanks for any help you can offer, cheers |
Is there a simple way the procedure can be explained 'step by step' - will the technique write the addresses to a text file with the right gaps between the addresses for a quick cut n paste ?Posted By: michael
Date Posted: 27 December 2003 at 11:14am
|
Yhe easiest thing for you might be just to export from the access database directly, just go to file export and choose csv as the destination, from there you can import it wherever you want. ------------- http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker |
Posted By: greytricky
Date Posted: 27 December 2003 at 11:50am
sorry guys, still struggling, ive exported the database as csv to a txt file but how do i just do the individual emails and not the whole lot, 
|
Posted By: michael
Date Posted: 27 December 2003 at 1:46pm
|
Ok, even easier, open the table in excess right click the column on it's header, select Copy, open a text file right click and select paste, unless you have 10000's of records that should not be a problem
------------- http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker |