How to read outlook email from vb.net and save attachments

  • Thread starter Thread starter Guest
  • Start date Start date
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 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 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
(e-mail address removed)
 
Karen,

It is a lot dependend on the mailsystem you use, however this seems to be a
link to a page where it seems to be more general solution (which I never
tried)
http://www.indyproject.org/indy.html

When it is about Microsoft systems, than this are some links

http://www.microeye.com/resources/res_outlookvsnet.htm

http://msdn.microsoft.com/library/d...html/frlrfsystemwebmailsmtpmailclasstopic.asp

http://msdn.microsoft.com/library/d.../cdosys/html/_cdosys_schema_configuration.asp

http://msdn.microsoft.com/library/d...y/en-us/exchanchor/htms/msexchsvr_cdo_top.asp


You will read about CDO's however there are more four it are (in
chronological order):

- CDO.DLL : CDO version 1.2.1
- CDONTS.DLL : CDO version 1.2.1 for Windows NT Server (not the same as CDO
version 1.2.1!)
- CDOSYS.DLL : CDO for Windows 2000
- CDOEX.DLL : CDO for Exchange 2000 Server

And when you want more information, than I would try it in your place in the
newsgroup
Microsoft.public.dotnet.languages.vb
(When you use C# just don't say it)

Because I have Jay not seen active some time in this newsgroup.

I hope this helps?

Cor
 
Back
Top