Solved

Using OLMail.Body

Posted on 2006-06-18
2
426 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Question has a verified solution.

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

Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

635 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