G
Guest
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 folder, and then execute a SQL
Server job that inserts the data into tables in our database.
What I"m hoping to do is have the process first open up my inbox ( or any
specific inbox to which the SQL Server Service account has access ), look for
an email from this particular email address, and then save the attachment to
a folder I specify. Then, the rest of the job that loads the data inth SQL
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 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 click
the link, 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. 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
(e-mail address removed)
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 folder, and then execute a SQL
Server job that inserts the data into tables in our database.
What I"m hoping to do is have the process first open up my inbox ( or any
specific inbox to which the SQL Server Service account has access ), look for
an email from this particular email address, and then save the attachment to
a folder I specify. Then, the rest of the job that loads the data inth SQL
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 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 click
the link, 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. 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
(e-mail address removed)