DoCmd.SendObject and CDO

[mike60smart]

Can you use Application.Object with Thunderbird client so Access can manipulate incoming/outgoing mail?

Hi
All I have used it for is just to send Emails

 

[isladogs]

Is new outlook a browser based webmail site, or is it a client executable app installed on desktops?

Desktop

 

[BlueSpruce]

Hi
All I have used it for is just to send Emails

It's been installed on my PC's for 3 years and I have S/MIME email certificates setup with my email accounts for encryption and sender/recipient authentication, but I have never integrated Thunderbird with Access.

 

[The_Doc_Man]

Can you use Application.Object with Thunderbird client so Access can manipulate incoming/outgoing mail?

According to my research, no. You CAN deal with inbound mail but it doesn't use a single "container" object for all of its data. It is more of a multi-file scenario. It uses SMTP for outbound (like Outlook and CDO) and uses either IMAP or POP3 for inbound mail. Thunderbird is apparently based on a Firefox "core" for a lot of its code, so you know it will have web-like controls. I've never used it but when I was still working for the Navy, they allowed Thunderbird on the government computers. To do that, you know it had to pass muster through some really picky IT guys & gals.

 

[BlueSpruce]

According to my research, no. You CAN deal with inbound mail but it doesn't use a single "container" object for all of its data. It is more of a multi-file scenario. It uses SMTP for outbound (like Outlook and CDO) and uses either IMAP or POP3 for inbound mail. Thunderbird is apparently based on a Firefox "core" for a lot of its code, so you know it will have web-like controls. I've never used it but when I was still working for the Navy, they allowed Thunderbird on the government computers. To do that, you know it had to pass muster through some really picky IT guys & gals.

I do like Thunderbirds security features, e.g. it generates OpenPGP keys that can be used for encrypting outgoing mail and decrypting incoming. It's too bad it cannot be integrated with Access.

 

[The_Doc_Man]

I have seen some articles that suggest you can control Thunderbird from Access via SHELL commands. Otherwise, unfortunately, no direct control.

 

[cheekybuddha]

Daniel Pineault has shown some exapmles:

VBA – Send E-mail Using Mozilla Thunderbird

VBA – Thunderbird Automation With Embedded Images

 

[spaLOGICng]

I wish MS would bring back the Access 2010 feature that sent emails to gather data entry and the email replies would automatically insert the data into tables. I used it a lot until MS deprecated it.

With M365 E3, I have opted to get the necessary end points using PowerAutomate, inserting the information into a List Table and then linking the List into Access.

 

[BlueSpruce]

With M365 E3, I have opted to get the necessary end points using PowerAutomate, inserting the information into a List Table and then linking the List into Access.

Glad that works for you, however, I'm not going to subscribe to an E3 plan to use PowerAutomate and SharePoint Lists just to collect data from remote users. I can roll my own VBA to ETL the data from PST and OST files.

 

[BlueSpruce]

Daniel Pineault has shown some exapmles:

VBA – Send E-mail Using Mozilla Thunderbird

VBA – Thunderbird Automation With Embedded Images

I didn't see anything in Daniel's posts about manipulating incoming Thunderbird emails, and SendMail via Thunderbird requires using pure HTML and SendKeys, which I am not fond of.