473,769 Members | 3,329 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Know of an Access procedure to open eMails in a named OutLook Express folder, search 'n extract eMail addr in body text?

MLH
I routinely save failure notices from mail servers
bouncing mail back to me that I sent with invalid
address. I would like to write an access procedure
in my contacts database that would open the
bounced mail messages, find eMail address(es)
& write 'em to a table. Later, I could go through
the table, comparing eMail addrs found in there
against those in tblContacts. I could set a flag
in tblContacts records to indicate those I need
to call & request updated eMail address.
Nov 12 '05 #1
2 2409
TC
But do all the bounce messages identify the failed email address in a
predictable fashion?

TC
"MLH" <CR**@NorthStat e.net> wrote in message
news:gl******** *************** *********@4ax.c om...
I routinely save failure notices from mail servers
bouncing mail back to me that I sent with invalid
address. I would like to write an access procedure
in my contacts database that would open the
bounced mail messages, find eMail address(es)
& write 'em to a table. Later, I could go through
the table, comparing eMail addrs found in there
against those in tblContacts. I could set a flag
in tblContacts records to indicate those I need
to call & request updated eMail address.

Nov 12 '05 #2
MLH
No, but I've got working procedures that extract eMail addresses
from long text strings. They should do nicely. I just need help
opening the email msgs, reading their body text & saving that
to a memo field in a table record.

xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx xxxxx
On Tue, 11 Nov 2003 10:56:14 +1200, "TC" <a@b.c.d> wrote:
But do all the bounce messages identify the failed email address in a
predictable fashion?

TC
"MLH" <CR**@NorthStat e.net> wrote in message
news:gl******* *************** **********@4ax. com...
I routinely save failure notices from mail servers
bouncing mail back to me that I sent with invalid
address. I would like to write an access procedure
in my contacts database that would open the
bounced mail messages, find eMail address(es)
& write 'em to a table. Later, I could go through
the table, comparing eMail addrs found in there
against those in tblContacts. I could set a flag
in tblContacts records to indicate those I need
to call & request updated eMail address.


Nov 12 '05 #3

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

Similar topics

10
5572
by: MLH | last post by:
I print to a device that creates a PDF. Knowing the filename, how can I then embed the PDF into the body text of an OutLook Express outbound email & send to a specified address in a table? I want recipient addressees to see the report in the body text window of their email when they open it. I was thinking also about attaching the PDF file to the eMail for those having "text only" email software. I need to automate both of these tasks from...
4
4868
by: MLH | last post by:
I would like to configure OutLook Express so that it does not attempt to resend eMails in the Outbox folder whenever new sends are made From Access. The ISP's server rejects some eMail address immediately... Things like JohnDoe@aol. (an incomplete address) and sometimes NonExistent@NorthState.net (if NorthState is my ISP, its mail server knows IMMEDIATELY that NonExistent is NOT a valid mailbox in their system.
6
4753
by: Peter Frost | last post by:
Please help I don't know if this is possible but what I would really like to do is to use On Error Goto to capture the code that is being executed when an error occurs. Any help would be much appreciated. Thanks in advance
11
6600
by: Grasshopper | last post by:
Hi, I am automating Access reports to PDF using PDF Writer 6.0. I've created a DTS package to run the reports and schedule a job to run this DTS package. If I PC Anywhere into the server on where the job is running, the job runs sucessfully, PDF files got generated, everything is good. If I scheduled the job to run at the time that I am not logged into the server, Access is not able to print to the printer. The error is pretty...
4
2752
by: PitchBlackSheep | last post by:
I have an office of Real Estate agents who use our (single) Access 2000 database to keep track of clients. Our agents email our clients everyday using Outlook 2000. I'm trying to find a way to have those emails associated with the client's record. Any ideas? All I need is a nudge in the right direction ;) Thank you in advance!!!
0
1119
by: bobdydd | last post by:
Hi Everybody Can anyone help with this mindbender We are writing an application that uses a VB built DLL to send emails using CDO 1.21. Whether we use the VB DLL or code the CDO stuff direct into Access makes no difference.
2
10523
by: mik.sjoblom | last post by:
Hello, I have developed a Access application that needs to read mail from Outlook, versions on Access and outlook are 2003. In the code i use mapi to connect to outlook. When i tries to read the subject of a message outlook displays "A program is trying to access e-mail adresses you have stored in Outlook. Do you want to allow this." And then i can allow access for max 10 minutes. My application is use scheduled statupm creating reports...
6
2623
by: rn5a | last post by:
In a shopping cart app, when a user finalizes his order, records from a temporary table named 'TempCart' get inserted into another table name 'Orders' after which the records from 'TempCart' are deleted. 'TempCart' has the following columns: UserID int (no NULLs) Carpet int (NULLs allowed) Color int (NULLs allowed) Engine int (NULLs allowed) Total decimal(10, 2) (NULLs allowed)
0
1726
by: Michiel Overtoom | last post by:
Ahmed wrote... I'm not sure if you are able to bypass Outlook (and have Python fetch the mail itself using poplib), but if you are, the following code might be useful. I use this to pry apart emails which might contain multiple MIME parts. from email.Parser import Parser from rfc822 import parseaddr import poplib
0
10211
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
9993
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
8870
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
7406
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
6672
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
5447
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3958
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
3561
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2815
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.