如何在VBA中格式化特定的邮件值 [英] How to format specific mail value in VBA

问题描述

我想使用vba与RegEx验证特定的邮件值.

I want to validate specific mail value with RegEx using vba.

示例: [e-mail]

用户输入的电子邮件必须完全包含 @ desktopfromanoth.com .我可以使用RegEx进行验证吗?

User input email must exactly include @desktopfromanoth.com. Can I validate that with RegEx?

我的代码在这里:

Private Function ValidateEmailAddress(ByRef strEmailAddress As String) As Boolean  
    Dim objRegExp As New RegExp

    objRegExp.IgnoreCase = True
    objRegExp.pattern = "^[\w-\.]+@([a-z]{16}+\.)+[A-Za-z]{2,3}$"
    ValidateEmailAddress = objRegExp.Test(strEmailAddress)
End Function

推荐答案

以下内容将验证以 @ desktopfromanoth.com

^[_a-z0-9-]+(.[a-z0-9-]+)@desktopfromanoth\.com$

有关更多信息，请参见 99.99％有效的电子邮件地址正则表达式.

For further information see Email Address Regular Expression That 99.99% Works.

如果要匹配多个电子邮件地址，请使用以下内容:

If you want to match multiple email addresses use the following instead:

[_a-z0-9-]+(.[a-z0-9-]+)@desktopfromanoth\.com

请参见 https://regex101.com/r/PjQKDx/1

这篇关于如何在VBA中格式化特定的邮件值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！