returned emails

  • Thread starter Thread starter David S.
  • Start date Start date
D

David S.

Hello,

I have a list of email addresses that I process out
through Access. The bad ones come back to my Outlook
account. I then export those returns into another Access
table.

My question: Is there a utility or function that will
extract the email address from the return "Undeliverable"
message which usually looks like the below? Thanks.

David S.

Your message

To: (e-mail address removed)
Subject: DBV 12/31/2003
Sent: Wed, 31 Dec 2003 05:05:57 -0500

did not reach the following recipient(s):

(e-mail address removed) on Wed, 31 Dec 2003 05:06:02 -
0500
The recipient name is not recognized
The MTS-ID of the original message is:
c=us;a= ;p=u.s. house of
re;l=IMS030312311006YDAWCXRN
MSEXCH:IMS:U.S. House of Representatives:U.S.
House:IMS03 0 (000C05A6)
Unknown Recipient
 
Um, lucky that's not his real email address!

Otherwise he'd better start saving up for viagra tablets etc. ...

As for extracting the addresses: if you have the message text in a string
variable or table field, you'd just use the Instr(), Left$(), Mid$() and/or
Trim$() functions to look for relevant strings and characters ("To:", "@")
and pull out the address. Do you realize that, or are you just not sure
exactly how to those functions in sequence?

HTH,
TC
 
Back
Top