Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - Lifting Email Addresses from Access
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Lifting Email Addresses from Access

 Post Reply Post Reply
Author
greytricky View Drop Down
Groupie
Groupie
Avatar

Joined: 01 December 2003
Location: United Kingdom
Status: Offline
Points: 48
Post Options Post Options   Thanks (0) Thanks(0)   Quote greytricky Quote  Post ReplyReply Direct Link To This Post Topic: Lifting Email Addresses from Access
    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

Back to Top
fernan82 View Drop Down
Mod Builder Group
Mod Builder Group
Avatar

Joined: 17 November 2002
Location: United States
Status: Offline
Points: 362
Post Options Post Options   Thanks (0) Thanks(0)   Quote fernan82 Quote  Post ReplyReply Direct Link To This Post Posted: 27 December 2003 at 12:01am
Read on the FileSystemObject and Stream Object, either one can write to a text file, just loop thru the recordset and write all the addresses to a file....
FeRnAN
Back to Top
greytricky View Drop Down
Groupie
Groupie
Avatar

Joined: 01 December 2003
Location: United Kingdom
Status: Offline
Points: 48
Post Options Post Options   Thanks (0) Thanks(0)   Quote greytricky Quote  Post ReplyReply Direct Link To This Post 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.  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 ?

Thanks for any help you can offer, cheers

Back to Top
michael View Drop Down
Senior Member
Senior Member
Avatar

Joined: 08 April 2002
Location: United States
Status: Offline
Points: 4670
Post Options Post Options   Thanks (0) Thanks(0)   Quote michael Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
greytricky View Drop Down
Groupie
Groupie
Avatar

Joined: 01 December 2003
Location: United Kingdom
Status: Offline
Points: 48
Post Options Post Options   Thanks (0) Thanks(0)   Quote greytricky Quote  Post ReplyReply Direct Link To This Post 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,
Back to Top
michael View Drop Down
Senior Member
Senior Member
Avatar

Joined: 08 April 2002
Location: United States
Status: Offline
Points: 4670
Post Options Post Options   Thanks (0) Thanks(0)   Quote michael Quote  Post ReplyReply Direct Link To This Post 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

 

Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.