<div>
I don't really see how I've helped you here - I just asked for clarification.<br />
<br />
While I know a question can sometimes prompt a re-think and hence solution, I doubt that's what I've done for you here :-)<br />
<br />
You don't have to accept to close out a question.<br />
You can always post in Community support to have a question deleted.<br />

</div>


I don't really see how I've helped you here - I just asked for clarification.

While I know a question can sometimes prompt a re-think and hence solution, I doubt that's what I've done for you here :-)

You don't have to accept to close out a question.
You can always post in Community support to have a question deleted.


<div>
<div class="content wysiwyg-content">
I have the following piece of code which makes up a larger module that essentially inputs the contents of an email into a database table@<br />
<br />
Rst.AddNew<br />
&nbsp; &nbsp; &nbsp; &nbsp; Rst!Name = OlMail.SenderName<br />
&nbsp; &nbsp; &nbsp; &nbsp; If InStr(1, OlMail.Subject, &quot;Accept&quot;) &gt;&nbsp;0 Then<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Rst!Status = &quot;Attending&quot;<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Rst!datesent = OlMail.ReceivedTime<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; OlMail.Move OlAccept<br />
<br />
Now this adds the sender, subject line and recieved date.<br />
<br />
I wish now to add the body of the email.<br />
<br />
This can be done by adding another line - &nbsp;Rst!content = OlMail.Body<br />
<br />
But I wish to take this abit further and get it to add the contents of a single line to a single field in database.<br />
<br />
Does anybody have any suggestions as to how I might accomplish this ?
</div>
</div>


I have the following piece of code which makes up a larger module that essentially inputs the contents of an email into a database table@

Rst.AddNew
        Rst!Name = OlMail.SenderName
        If InStr(1, OlMail.Subject, "Accept") > 0 Then
            Rst!Status = "Attending"
            Rst!datesent = OlMail.ReceivedTime
            OlMail.Move OlAccept

Now this adds the sender, subject line and recieved date.

I wish now to add the body of the email.

This can be done by adding another line -  Rst!content = OlMail.Body

But I wish to take this abit further and get it to add the contents of a single line to a single field in database.

Does anybody have any suggestions as to how I might accomplish this ?

Using OLMail.Body

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.