Results 1 to 3 of 3
  1. #1
    timesscript is offline Advanced Beginner
    Windows 8 Access 2013
    Join Date
    May 2015
    Posts
    34

    Using VBA to retrieve / download / recieve / emails from server (POP / IMAP ) and put in tables

    I have looked through what seems like hundreds of threads on this and other forums and it seems like everyone hints at this being possible but nobody actually seems to know how.

    I would like to use VBA to check an email (POP or IMAP, don't care), download the unread emails, delete them, and save the data into access tables. (Perhaps the subject, body, and from email address)



    I understand that winsock can do this, but can't find any examples. I have found some 3rd party APIs, but they all have a charge.

    I don't want to use outlook, I have a setup right now to send emails without outlook that works well on servers I use that don't have outlook installed, and skipping that middleman would be best for me.

    Appreciate any help you can offer,

    Thanks!

  2. #2
    timesscript is offline Advanced Beginner
    Windows 8 Access 2013
    Join Date
    May 2015
    Posts
    34
    Still very interested in this issue. Any solutions?

  3. #3
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,398
    you can use CDO to send emails - plenty of code examples around as to how to do that and looks like you have resolved that one. But to receive emails will require 3rd party API's and they do come with a charge.

    However a quick look online found this thread which may work for you, doesn't look like there is a charge involved but haven't drilled all the way down

    http://stackoverflow.com/questions/1...o-in-vba-excel

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 10-08-2015, 09:15 AM
  2. Replies: 5
    Last Post: 04-30-2015, 02:00 PM
  3. Replies: 3
    Last Post: 08-18-2012, 03:25 AM
  4. Replies: 5
    Last Post: 07-17-2011, 08:57 AM
  5. Replies: 1
    Last Post: 06-20-2007, 07:26 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums