<div>
In the string... is the username accurately presented in the string? &nbsp;If so, can you just append the username to your domain name to recreate the email address?<br />
<br />
There are a few ways to extract a username from a string, but you may need to identify a pattern... <br />
<br />
e.g. &nbsp;assuming the username is preceded by &quot;...&quot; and forms the rest of the string (and there are no other occurrences of &quot;...&quot; in the string) then you could do something like:<br />

<pre><code class="code-1 nolinks" id="code-20-41484749-1"><span>myUsername = split(string, &quot;...&quot;)(0)</span>
</code></pre>
</div>


<div>
Hi, thanks for your comment. I didn't post the full address as I wasn't sure of security implications with other people on the net but I will now post it in full senderemailaddress string, albeit in a scrambled format. As you can see the last part of the address is the username which happens to be the user name part of the true email address so I can do an instrrev and grab what comes after the last &quot;-&quot; in the string but I was hoping there would be a more robust option. Is there no safer way?<br />
<br />
/O=EXCHANGELABS/OU=EXCHANG<wbr />E ADMINISTRATIVE GROUP (FYDIBPI3I3SYDIT)/CN=RECIP<wbr />IENTS/CN=5<wbr />978029F591<wbr />240D597AA8<wbr />DEF8111AF2<wbr />E-USERNAME<wbr /><br />
<br />
<br />
The senderemailaddress I am searching for is username@mydomain.com.au
</div>


<div>
Sorry for the delay in finalising this. I am finally back to it and will use your suggestion. Thanks
</div>


<div>
<div class="content wysiwyg-content">
I have developed some VBA that is intended to create an auto reply to a correctly formatted message. However step one of the process is to check the senderemailaddress and I am having trouble with senders from my own domain. Instead of the senderemailaddress coming in as username@mydomain.com it's coming in as something like: &quot;/O=EXCHANGELABS/OU=EXCHAN<wbr />GE ADMINISTRATIVE GROUP (FY....LT)/CN=RECIPIENTS/C<wbr />N=5959...E<wbr />-USERNAME&quot;<wbr /> &nbsp;How can I get the normal format username to test for validity
</div>
</div>


I have developed some VBA that is intended to create an auto reply to a correctly formatted message. However step one of the process is to check the senderemailaddress and I am having trouble with senders from my own domain. Instead of the senderemailaddress coming in as username@mydomain.com it's coming in as something like: "/O=EXCHANGELABS/OU=EXCHANGE ADMINISTRATIVE GROUP (FY....LT)/CN=RECIPIENTS/CN=5959...E-USERNAME"  How can I get the normal format username to test for validity

Problem checking senderemailaddress with VBA

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.