Couple of things you could try (I've had a go at them all, so they are achievable !):
i. Would you be able to design a web page (.asp) and use CDONTS to get the emails off. This is the preferred method that I use on our Intranet. ii. A VB application would be real easy. I've used VB and VBA to connect through to a database (Access or SQL) and by adding the MAPI control, the email is easy. iii. A little more complex, but possibly better for users would be to use Outlook to connect to the database and email customers 'the usual way'. Outlook forms can be developed to connect to an external database via ODBC and, with some navigation buttons, could be made to work quite nicely inside your normal mail package. iv. I've also used a third party mail application (i.e. blat) from within a batch file to do simple SMTP broadcasts. This may be the easiest if your proficient with command scripting. Hope these ideas help. Tim -----Original Message----- From: julian brunt [mailto:[EMAIL PROTECTED]] Sent: Thursday, 28 November 2002 4:06 a.m. To: NT 2000 Discussions Subject: OT Access query & E-mail This may be an odd one... How would I go about e-mailing people whose details are stored in an access database? We currently use Office XP and our customer contacts are stored in a monster Access DB with 1000's of entries. I have been asked to design a method of e-mailing these people directly. Any help would be appreciated. Regards JUlian Brunt IT Support Manager Thames Valley Strategic Health Authority _________________________________________________________________ The new MSN 8: smart spam protection and 2 months FREE* http://join.msn.com/?page=features/junkmail ------ You are subscribed as [EMAIL PROTECTED] Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe send a blank email to %%email.unsub%% DISCLAIMER: The content of this email is confidential and may contain legally privileged information intended only for the individual or entity named above. Access to this message by anyone else is unauthorised. If you are not the intended recipient, please be advised that the use, distribution and publication of the above information is prohibited. If you have received this email in error, please contact Domainz by returning the email and destroying the original. Thank you. ------ You are subscribed as [email protected] Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe send a blank email to [EMAIL PROTECTED]
