S
small caps
Hi, how can I:
a) pull the query from somewhere and send it by e-mail automatically. E.g. I
want to take a temperature table from
http://www.wunderground.com/history...tml?req_city=NA&req_state=NA&req_statename=NA
where 2009/7/10 is the date of yesterday put it into an e-mail and send it
automatically each day at 8 o'clock?
b) if this is not possible, how can I send an e-mail with the attachment
c:\Documents\query20090710.xls each day at 8 o'clock?
my boss wants this automatized, I know how to write the VBA code for Excel,
but don't have a clue what do I have to do in Outlook. Every help is
appreciated,
small caps
a) pull the query from somewhere and send it by e-mail automatically. E.g. I
want to take a temperature table from
http://www.wunderground.com/history...tml?req_city=NA&req_state=NA&req_statename=NA
where 2009/7/10 is the date of yesterday put it into an e-mail and send it
automatically each day at 8 o'clock?
b) if this is not possible, how can I send an e-mail with the attachment
c:\Documents\query20090710.xls each day at 8 o'clock?
my boss wants this automatized, I know how to write the VBA code for Excel,
but don't have a clue what do I have to do in Outlook. Every help is
appreciated,
small caps