473,973 Members | 1,830 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

How to read outlook email from within VB.Net and download attachme

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
kl*****@yahoo.c om
Nov 22 '05 #1
1 2806
No problem just to prevent opening all times
Nov 22 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
451
by: Karen Grube | last post by:
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
1
669
by: Karen Grube | last post by:
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
1
4503
by: Nicole | last post by:
Hello! I hope there is someone out there who can shed some light on this for me. I have a module that is supposed to look at an access table, pull out each bid record, link to another table to find all of the people to send the email to and link to one more table to find who should be cc'd on the note. All of this works fine, except.... The arrays for the To and CC seem to exclude names from the list if there are multiple recipients...
4
5115
by: Max | last post by:
Hi, I would like to have a button and a combo box with options to select various versions of Microsoft Outlook: 2002, 2003. The user selects the email client and clicks the button. The only things happening will be: a new email is created and some text is placed in the body, then the email window is displayed. The user can close the window or select some recipients and send the message. I would like some info on how to do this correctly....
2
12431
by: Karen Grube | last post by:
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 receive in my own inbox on my company's Outlook Exchange email server 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
1
1706
by: Jeff S via AccessMonster.com | last post by:
Hello, I got some code from http://www.fabalou.com/VBandVBA/lotusnotesmail.asp to send emails atomatically from access. It works but does not attach anything to the email I am trying to email the report "RP_NC Form" when I clic a button.. What s wrong in the following code?: Private Sub Command231_Click()
4
15091
by: Brian Hampson | last post by:
I recently upgraded to Outlook 2007 B2TR and have found that I can no longer code against MAPI.DLL It's gone :( Using C#, I used to get the MAPI session, and from that I could change the out of office. No longer. Does anyone know how to do this using the new Microsoft.Office.Core and Microsoft.Office.Outlook DLL's that are supposed to be the new replacements? Here's what I had that worked until Outlook 2007 came around:
0
3294
by: =?Utf-8?B?UGV0ZXI=?= | last post by:
I have an email account with btinternet.com that I can download my emails from within Outlook but (as I don't use their Broadband service) I am barred from sending to them. If I accidentally try to send a message I can remove it from my Outbox but I have inadvertently agreed to send a read receipt which does not appear in my Outbox but does cause Outlook to attempt to connect every few minutes & the POP server rejects the login. I...
12
10669
by: DeZZar | last post by:
Hi all, I'll explain my database first. Users input customer details that are required to complete a company document. The document merge etc is all working - the database saves the completed document to a variable directory based on form data. What I need to code into it now is a button that creates an email. The email has the same basic text each time but just needs to draw a
0
1566
by: brossyg | last post by:
I have some VBA code that creates an email in Access and sends it from Outlook. It is based on a query with a list of email addresses. It sends the first email to Outlook and then I have to manually click the SEND button in Outlook ... and then the second email is sent to Outlook ... and so on... The list of email addresses is getting quite long and I want to automate clicking the SEND button in Outlook from the VBA script...but don't know...
0
10160
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
11810
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
11560
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
10070
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
8453
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
7600
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
6409
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
6542
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
3
3755
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.