advice for new project

[geoffrey525]

I have a possible new project coming up where I have to write a database backend to keep track of customers. No biggie as I have plenty of db experience with vb. However, the next part of the program has to do with email and I don't have much experience with that. The project requires that I supply a gui that has a search screen. After inputting some keywords, it emails everyone in the database that has those keywords set up. It's for a small business though, so I can't justify convincing them to purchase sql server, but for this type of an application, I don't think access will cut it because I need the full text searching capability of sql server. I may just have the database hosted somewhere and have the app tie into that. But anyway, my main question is on the email portion. I need to learn how to either write a mini email program or use outlook or something like that. Anyone have any ideas or pointers? Thanks.

[Freshwater]

You may not what to use Access

But i have found it very good for firing out e-mails

with attachments or just text

Dim ac As Access.Application
    Set ac = New Access.Application
    'ac.DoCmd.OutputTo etc