X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> Outlook Automation / Thunderbird, Access 2007    
post Nov 24 2018, 11:04 AM

UtterAccess Editor
Posts: 10,433
Joined: 8-November 07
From: South coast, England

Hi All

I use Outlook Automation to transfer data from received e-mails to my Access Database, however as Outlook is no longer available as a standalone product (thank you MS!) I need to consider alternatives (e.g. Thunderbird?) however can I use Automation with Thunderbird to achieve the same thing, and if not, is there any other e-mail app that I could use?

I use Outlook Automation from Access to
1. Create various Outlook folders ,
2. Mark (specific) received e-mails (dependent on subject) as unread in any selected account and transfer these e-mails to the appropriate folder created in 1.
3. read these transferred e-mails, and extract relevant information which is saved to tables within the Access App.
4. mark e-mails successfully transferred as 'read'
5. Create and send e-mails that are not successfully read, to advise sender.

Warm regards
Go to the top of the page
post Nov 24 2018, 02:46 PM

Posts: 602
Joined: 25-January 16

Maybe. Review https://emailarchitect.net/eagetmail/kb/vb.aspx

That code is VB6 which is similar enough to VBA to often be easily adapted.

Attach File Manager is below Advanced editor window, click Go Advanced below Quick Reply window. To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
DEBUG! DEBUG! DEBUG! http://www.cpearson.com/Excel/DebuggingVBA.aspx
Go to the top of the page
post Jan 5 2019, 11:10 AM

UtterAccess VIP
Posts: 6,661
Joined: 30-June 11

MS has made it hard to locate, but it can still be purchased as a standalone product, see: https://www.microsoft.com/en-ca/p/outlook/c...t%3aoverviewtab

Daniel Pineault (2010-2018 Microsoft MVP)
Professional Help: http://www.cardaconsultants.com
Free MS Access Code, Tips, Tricks and Samples: http://www.devhut.net

* Design should never say "Look at me". It should always say "Look at this". -- David Craib
* A user interface is like a joke, if you have to explain it, it's not that good! -- Martin LeBlanc

All code samples, demonstration databases, links,... are provided 'AS IS' and are to be used at your own risk! Take the necessary steps to check, validate ...(you are responsible for your choices and actions)
Go to the top of the page

Custom Search

RSSSearch   Top   Lo-Fi    19th June 2019 - 04:38 PM