C
cred
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
(e-mail address removed) 3 2 23-04-2009
(e-mail address removed) 2 1 23-02-2009
(e-mail address removed) 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... Count1>2, 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 = (e-mail address removed)
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
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
(e-mail address removed) 3 2 23-04-2009
(e-mail address removed) 2 1 23-02-2009
(e-mail address removed) 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... Count1>2, 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 = (e-mail address removed)
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