Using OLMail.Body

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 ?
andyw27Asked:
Who is Participating?
 
Leigh PurvisDatabase DeveloperCommented:
Don't follow what you want.
To add which single line - to which field?
A single line from your body?  Which line - the first one?  Into where?  The content field?
Or different fields for different lines?
0
 
Leigh PurvisDatabase DeveloperCommented:
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.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.