Solved

Using OLMail.Body

Posted on 2006-06-18
2
416 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

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

813 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

14 Experts available now in Live!

Get 1:1 Help Now