Hi!
I hate to bother you all with this, but I don't know how best to approach
a particular task.
Here's the deal:
Once a month I personally (that is, in my own personal inbox on my company's
email server) receive an email from one of our vendors to which is attached a
text file (a comma-delimited data file containing the details of our monthly
billing).
My goal is to automate this process. Right now, I have to personally
download this attachment to a particular folderr, and then execute a SQL
Server job that runs inserts the data into tables in our database.
What I"m hoping to do is be able to schedule the job so that it first opens
up my inbox ( or any specific inbox), looks for an email from this particular
email address, and then saves the attachment to a folder I specify. Then,
the rest of the job can run as usual.
I think a lot of companies receive data as email attachments, but I'm not
sure how they automate the process of opening up the email and then saving
those attachments to a folder.
Additionally, one company (UPS) sends us a link to our billing file rather
than attaching it. Each month I have to open the email, right mouse clidk,
and then save the linked file. Is there a way I can automate the process of
reading the email, locating the link within the text of the email, and then
saving the linked file to a selected folder?
Perhaps there's a utility or program out there, like some kind of VB.Net
control or program, that will help with this.
Any advice would be greatly appreciated. However, I've already read BOL and
I"m still cluelss. I'm absolutely certain, though, that other companies are
doing precisely what I need to be doing. I just don't know how they're doing
it.
Thanks!
Karen Grube
kl*****@yahoo.com
