Solved

Using OLMail.Body

Posted on 2006-06-18
2
407 Views
Last Modified: 2012-08-14
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 ?
0
Comment
Question by:andyw27
  • 2
2 Comments
 
LVL 44

Accepted Solution

by:
Leigh Purvis earned 500 total points
ID: 16930903
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
 
LVL 44

Expert Comment

by:Leigh Purvis
ID: 17142811
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

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now