[AccessD] email validation

First, thanks to all! My primary concern is the formatting of the string.
This will be used as part of a process that currently emails Excel based
statements to approximately 800 corporations.

Jim



> Hah! See my reply to the previous message. Exactly my concern on this
> issue.
> Arthur
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart
> McLachlan
> Sent: January 8, 2006 5:52 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] email validation
>
> Are we talking about code to determine whether the format of a particular
> string is valid as an email address or whether  a particular email address
> resolves to a real mailbox?
>
> On 8 Jan 2006 at 13:12, MartyConnelly wrote:
>
>> Here is some vb code to validate email addresses subject to a free daily
>> limit or paid for via smtp mail server authentication at
>> www.internetfrog.com
>>
> ...
>>
>> Gustav Brock wrote:
> ...
>>
>>^(?:[\w\!\#\$\%\&'\*\+\-\/\=\?\^\`\{\|\}\~]+\.)*[\w\!\#\$\%\&'\*\+\-\/\=\?
>>
>>\^\`\{\|\}\~]+@(?:(?:(?:[a-zA-Z0-9](?:[a-zA-Z0-9\-](?!\.)){0,61}[a-zA-Z0-9]
>> >?
>>
>>\.)+[a-zA-Z0-9](?:[a-zA-Z0-9\-](?!$)){0,61}[a-zA-Z0-9]?)|(?:\[(?:(?:[01]?\d
>> >{ 1,2}|2[0-4]\d|25[0-5])\.){3}(?:[01]?\d{1,2}|2[0-4]\d|25[0-5])\]))$
>> >
>> >which claims to have a proven record (browse to 2004-04-28, 7:48 pm):
>> >
> ...
>> >>>>martyconnelly at shaw.ca 07-01-2006 07:35 >>>
>> >>>>
>> >There is quite a range of vaild email addresses including the old X400
>> >types Mastering Regular Expressions.  Is the best Owl book for regexp
>> >
>> > The book ends with an example regular expression to match
>> >an email address.
> ....
>> >Jim Moss wrote:
>> >
>> >>Does anyone have a good email validation module that they would be
> willing
>> >>to share?
>> >>
> --
> Stuart
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>