Page 1 of 2 12 LastLast
Results 1 to 15 of 16
  1. #1
    Join Date
    Sep 2008
    Location
    New Delhi
    Posts
    6

    Unanswered: Convert emails to records

    I use microsoft outlook. I receive 500 emails daily in microsoft outlook from the exchange server. I want the emails received in microsoft outlook to be automatically redirected to a database i.e Ms access or MY SQL or oracle or SQL Server.

    How can I do this? Which of the databases will be the best? Will I need any third party software to do this or this can be done directly without using any third party software. Thank in advance to all responding.


    Sweta_cool2003
    Last edited by Sweta_cool2003; 09-01-08 at 10:19. Reason: Addition

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    you can do this directly with MS Access using the Outlook library.. you need to add the outlook reference to your applciation. you cna then reads any email that comes into the relevant outlook folder. although I haven't tried it I think you can use VBA in Access to fully drive outlook to send & receive emails.

    I did write an app that used to extract sales details from emails which was pretty trivial (assuming you have a woring knowledge of VB/VBA and an enquiring mnd)
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Sep 2008
    Location
    New Delhi
    Posts
    6

    Convert emails to records

    Waiting for your code.

    Thanks!

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Quote Originally Posted by Sweta_cool2003
    Waiting for your code.

    Thanks!

    you can wait as long as you like, the application that used that code was no longer supported by me around 5 years ago and was deleted.

    its not that difficult
    you need to make sure the Outlook librry is aprt of your projects references
    you then need to open an Outlook object, having done that you can then trverese to outlook object lookng for the properties and methods you need to achieve what you want.

    Unless I have an excessive amount of time on my hands (either work is running slow, Im waiting for something or I'm bored), or the problem intrigues me I don't 'give' code.. In any event you need to make an effort to resolve your problem, either that or just google it.....
    I'd rather be riding on the Tiger 800 or the Norton

  5. #5
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    the whole project seems mad to me.
    why do you want to do this?

    ummmm, isn't outlook already a front-end application looking at a dedicated back-end database. i guess you wont build a better mail application or database than 1000 MicroSerfs so you might as well leave the mails-data where it is.

    why do you want to do this crazy thing?

    izy
    currently using SS 2008R2

  6. #6
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    I'm with IZY.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  7. #7
    Join Date
    Sep 2008
    Location
    New Delhi
    Posts
    6

    Convert emails to records

    Here is why I want to do it. Thanks for asking.

    I want to send the email to the db and then I want those mails to be fetched by 10 users through an applicaton within a LAN. Each user will fetch a mail one by one so the the same mail does not get locked by two or more users. After working on the fetched mail the user will then release the mail after updating the other corresponding fields for the mail in the db. I cannot fetch mails one by one in outlook and I will not know if the same mail has been read by the other users and the appropriate action taken.

  8. #8
    Join Date
    Sep 2008
    Location
    New Delhi
    Posts
    6
    Quote Originally Posted by izyrider
    the whole project seems mad to me.
    why do you want to do this?

    ummmm, isn't outlook already a front-end application looking at a dedicated back-end database. i guess you wont build a better mail application or database than 1000 MicroSerfs so you might as well leave the mails-data where it is.

    why do you want to do this crazy thing?

    izy
    Here is the reason. Thanks for asking.

    I want to send the email to the db and then I want those mails to be fetched by 10 users through an applicaton within a LAN. Each user will fetch a mail one by one so the the same mail does not get locked by two or more users. After working on the fetched mail the user will then release the mail after updating the other corresponding fields for the mail in the db. I cannot fetch mails one by one in outlook and I will not know if the same mail has been read by the other users and the appropriate action taken. Thanks for asking.

  9. #9
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Thanks for explaining

    You're going to have to follow Healdem's advice then.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  10. #10
    Join Date
    Apr 2004
    Location
    metro Detroit
    Posts
    634
    While your getting familiar with the Outlook object, check out folders. You may want to move emails out of the inbox to a seperate folder after they've been imported to access.

  11. #11
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    mmmmm, i'm still worried that you are trying hard to invent a square wheel when round wheels have been available for a long time.

    what i understood so far is that you have DATA buried somewhere in the mail and you want the DATA in a database. that's OK (at least i hope it is OK since i have applications doing that hundreds of times every day).

    so my next naïve question: which DATA where?

    ?? attached .CSV
    ?? sender address/subject/etc
    ?? fixed-format (or a limited number of fixed-formats) bodytext from which you could parse & extract the DATA automatically
    or ??
    (unfortunately most of the OR possibilities are a **disaster**)

    izy
    currently using SS 2008R2

  12. #12
    Join Date
    Sep 2008
    Location
    New Delhi
    Posts
    6
    Quote Originally Posted by izyrider
    mmmmm, i'm still worried that you are trying hard to invent a square wheel when round wheels have been available for a long time.

    what i understood so far is that you have DATA buried somewhere in the mail and you want the DATA in a database. that's OK (at least i hope it is OK since i have applications doing that hundreds of times every day).

    so my next naïve question: which DATA where?

    ?? attached .CSV
    ?? sender address/subject/etc
    ?? fixed-format (or a limited number of fixed-formats) bodytext from which you could parse & extract the DATA automatically
    or ??
    (unfortunately most of the OR possibilities are a **disaster**)

    izy

    Let me explain a bit for clarity and to arrive at a feasible solution.
    I use microsoft outlook. I receive 500 emails daily in microsoft outlook from the exchange server. I want the emails received in microsoft outlook to be automatically redirected to a database i.e Ms access or MY SQL or oracle or SQL Server.
    How can I do this? Which of the databases will be the best? Will I need any third party software to do this or this can be done directly without using any third party software. Thank in advance to all responding.


    Here is why I want to do it.
    I want to send the email to the db and then I want those mails to be fetched by 10 users through an applicaton within a LAN. Each user will fetch a mail one by one so the the same mail does not get locked by two or more users. After working on the fetched mail the user will then release the mail after updating the other corresponding fields for the mail in the db. I cannot fetch mails one by one in outlook and I will not know if the same mail has been read by the other users and the appropriate action taken.


    An example:
    Let us for example have 3 mails received in Inbox. The mails will have three fields like Name, Contact No and Message. The mails will be moved to the DB with all these fields and the data against each field. Let us now call each mail a record once it has moved to the DB. Three more fields like "category", "subcategory" and "response" to be sent to the mail sender will be added to each record in the DB to each mail(record) received. The front end of the application will show each message of the fetched record and the category and subcategory fields for corresponding fetched record will also be chosen through a drop down menu by the person who has fetched that email. The chosen option from the drop down through the front end will update the field of the db for that particular record which has been fetched. In short, the drop down will categorise the mail and then sub categorise. As per categorisation the "response" field will get automatically updated will already stored formats of messages. Now the contact number of the user and the corresponding responses will be shown and exported to an excel sheet.

  13. #13
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    FYI peeps:
    http://www.dbforums.com/showthread.p...=1#post6356048

    Duped in SQL Server forum. I think you guys are much more likely to produce something of use for Sweta (this really isn't a SQL Server problem) so just carry on as you were
    Testimonial:
    pootle flump
    ur codings are working excelent.

  14. #14
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    It's no good - I've got to byte. Why are the emails sent in the first place? Why distribute data like this? Without knowing any more about it, it just seems like an unnecessary complication.
    Testimonial:
    pootle flump
    ur codings are working excelent.

  15. #15
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Well I sure wouldn't want to have to deal with 500 e-mails every day, I'd quit.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •