Automate Email Distribution List



I have built a fairly simple database to manage contact information
for about 300 clients. Some of these have requested that I send them
our publications by email rather than post. I have created a query
which culls the names and addresses of these contacts. Then I export
the result to a .csv file and edit it into a distribution list
format ... (ie FirstName LastName <em...@xxxxxxxxxx>; ... etc.)

Is there a way for me to automate this same process placing the entire
list in the to: portion of an outgoing message sent via gmail?

I have no experience with VBA so please be gentle.
.



Relevant Pages

  • Re: Supporting multiple oracle versions in a trigger
    ... This is a very unscalable solution. ... Why would you do that in a database? ... > - Clients can add/modify their data collection requirements in minutes ... > - Clients can connect to the database with 3rd party sql tools and access ...
    (comp.databases.oracle.server)
  • Re: Poly Couples
    ... Essentially - different versions for different clients. ... insist that you use their existing database which is from a different ... vendor, and the structure is different than the one you use originally. ... characters would mark variable insertion place-holders in the SQL. ...
    (comp.object)
  • Re: Programatically adding Fields to an existing Database (using SQL)
    ... database to new clients, ... TADODataSet method "GetFieldNames" in order to find the fields the ...
    (borland.public.delphi.database.ado)
  • Re: Out of Response Time Calculation
    ... I have attempted to build the database as you describe but I must be doing ... I have built the tables as you described, I have then built a form with the ... > On your Form you would have textboxes for TimeOpened and TimeClosed, ... > and for TimeOpenedMet, use a Control Source ...
    (microsoft.public.access.forms)
  • Re: Synching between Access and MSSQL
    ... The clients will only be disconnected a matter of a few days in most cases ... The challenge is that the information has to be tracked in a main database ... Working out the details of how to keep the data synchronized and accomodate ... I found code to allow an ADO connection to a local Access database but now I ...
    (microsoft.public.access.externaldata)