Print Page | Close Window

Parsing Email Addresses

Printed From: Roger's Access Library
Category: Other Download Libraries
Forum Name: Macgregor, David
Forum Description: David Macgregor's Library
URL: www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=520
Printed Date: 21 Oct 2017 at 6:24am


Topic: Parsing Email Addresses
Posted By: David Macgregor
Subject: Parsing Email Addresses
Date Posted: 26 Oct 2009 at 4:39am

I have an application that (among other things) sends emails, often with attachments, using Outlook automation.  Unfortunately,  the routine crashed periodically, displaying a number of different error messages. When I looked into it further, I found all the errors appear to be related to incorrect email address formats.  After I found and corrected all the email addresses with illegal formats, the routine ran to completion without  error.

I decided I needed a reasonably robust function to parse email addresses. I couldn't find one online, so I wrote my own.  The following is that routine:
 
Access 2000 format: http://www.rogersaccesslibrary.com/forum/uploads/45/Parse_Email.zip - Parse_Email.zip



Print Page | Close Window