• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 462
  • Last Modified:

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!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 ?
  • 2
1 Solution
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?
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.
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.

Join & Write a Comment

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now