Hey guys,I have been looking for an issue that I have.I have a database with a number of customer email addresses in themand I want to send an email to a number of them based on a query(essentially to limit who gets the email), what I need to know is howto do this.Any help would be greatly appreciated.

TimWal wrote:> Hey guys,>> I have been looking for an issue that I have.>> I have a database with a number of customer email addresses in them> and I want to send an email to a number of them based on a query> (essentially to limit who gets the email), what I need to know is how> to do this.>> Any help would be greatly appreciated.Sounds like you need to open a recordset based on your query, and thenloop through the records and send a message to each (use SendObject,or automate Outlook, or use CDOSys available at the MS site).  Searchthe NG.  There are examples all over the place.  There's a nice one atDanny Lesandrini's site.  www.amazecreations.com  then look for thedatabase stuff.