<div>
Will there be asterisks anywhere else in the message text?
</div>


Will there be asterisks anywhere else in the message text?

<div>
Will there always be the same number of asterisks?<br />
<br />
Is this the only text in the body?<br />
<br />
You might be able to use the Split() function to parse the text on the vbcrlf character<br />
<br />
myText = Split(strBody, vbcrlf)<br />
<br />
Then loop through the myText array looking for the asterisks, then concatenate the array elements between the &quot;'***********&quot; strings, or you could use the Replace function, something like:<br />
<br />
myText = Replace(strBody, &quot;*&quot;, &quot;&quot;)
</div>


Will there always be the same number of asterisks?

Is this the only text in the body?

You might be able to use the Split() function to parse the text on the vbcrlf character

myText = Split(strBody, vbcrlf)

Then loop through the myText array looking for the asterisks, then concatenate the array elements between the "'***********" strings, or you could use the Replace function, something like:

myText = Replace(strBody, "*", "")

<div>
I could look for the word &quot;denial:&quot; and then I would need to pull the text until it gets to second line of astrisks. &nbsp;Yes, the two lines of asterisks will be the only ones in the emai.
</div>


I could look for the word "denial:" and then I would need to pull the text until it gets to second line of astrisks.  Yes, the two lines of asterisks will be the only ones in the emai.

<div>
That is totally awesome! Very elegant! Works like a charm. Thanks!!
</div>


That is totally awesome! Very elegant! Works like a charm. Thanks!!

<div>
<div class="content wysiwyg-content">
I am pulling the body of out of an Outlook message. &nbsp;There are two rows of asterisks and I need to pull the text between the two rows. <br />
<br />
There are various lines of text above the asterisks. &nbsp;The text between the asterisks will have various lines too. Thanks so much!<br />
<br />
'**********************<br />
Reason for denial: <br />
'**********************
</div>
</div>


I am pulling the body of out of an Outlook message.  There are two rows of asterisks and I need to pull the text between the two rows. 

There are various lines of text above the asterisks.  The text between the asterisks will have various lines too. Thanks so much!

'**********************
Reason for denial: 
'**********************

find find asterisks in a string

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.