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: 28 Mar 2024 at 8:32am
Software Version: Web Wiz Forums 12.03 - http://www.webwizforums.com


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

Forum Software by Web Wiz Forums® version 12.03 - http://www.webwizforums.com
Copyright ©2001-2019 Web Wiz Ltd. - https://www.webwiz.net