Importing from outlook

  • Thread starter Thread starter Suttd via AccessMonster.com
  • Start date Start date
S

Suttd via AccessMonster.com

Hi,

I seem to have fallen over at the first hurdle and need your help:

I receive an email first thing every morning with a data link in it
like this:

https://esales3.nj.ssmb.com/esalesauth/ReportAccess.smvc?Resource=/ftp_p
ub/FsaRep4_20060815.xls

when you click it, it requires a user name and password before opening
as a excel spreadsheet.

wondered if you knew of a way of importing it into MS Access2000 ?

Plus the name of the link changes on a daily bases as it has a time
stamp?

Any idea's?


Thanks
 
Suttd said:
Hi,

I seem to have fallen over at the first hurdle and need your help:

I receive an email first thing every morning with a data link in it
like this:

https://esales3.nj.ssmb.com/esalesauth/ReportAccess.smvc?Resource=/ftp_p
ub/FsaRep4_20060815.xls

when you click it, it requires a user name and password before opening
as a excel spreadsheet.

wondered if you knew of a way of importing it into MS Access2000 ?

Plus the name of the link changes on a daily bases as it has a time
stamp?

Any idea's?

Thanks
Click to expand...


I take it this can not be achieved then?
 
It can be achieved, but it's not exactly simple. I think something like
this would be needed:

1) You could write VBA code to calculate today's filename and URL, or
else automate Outlook to grab the URL from today's email.

2) Use a Web Browser control to download the file and save it to a local
drive. (The form of the URL you posted makes me wonder if the file is
available via ftp: if so, it might be simpler to get it that way.)

3) use the technique at
http://alexdyb.blogspot.com/2005/04/how-to-import-password-protected-excel.html
 
Back
Top