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
Printed Date: 14 Jun 2021 at 1:34pm
Software Version: Web Wiz Forums 12.03 -

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: -

Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.03 -
Copyright ©2001-2019 Web Wiz Ltd. -