Hi there... not sure if this is the correct place for this. If not please
tell me where to move it! Cheers...

Basically at the moment I have an SQL table with data relating to email
addresses as such:

Email Count1 Count2 Date_added
3 2 23-04-2009
2 1 23-02-2009
1 1 23-01-2009

etc...

I have written a query in MS SQL that creates a new table, with only email
addresses inside a certain criteria... Count12, Count2=2, <= 14 days old

And this is linked to a pivot table in excel. At the moment, every day I am
running the code from MS SQL Manager, creating a duplicate excel sheet for
that specific date and refreshing the data from the SQL form and adding the
emails that are flagged to a list.

Finally the NEW emails (for each day) are being moved into another sheet
(request form) to be sent off with some standardised text before them, like
customer_email =

Ideally what I want to do is automate this to a certain extent... perhaps
run this all from an Excel sheet? I am particularily frustratred with the
last bit... copying only the NEW emails to the request form. Emails can
appear on the original database upto 14 days after they are relavent so I
can't use the ones from the last day... I need to use the ones which haven't
appeared ever before.

I think the help I predominantly need is with the logistics of it all and
the linking SQL to Excel, but I'm at a loss for the last bit! Any help you
can provide would be awesome as I'm really stumped on this and wasting a lot
of time doing it manually!

I have a little bit of experience with Macros/VB so if that is the way to go
could you give me some tips?

Thanks