Email via Thunderbird (or other email client)

[kwor]

I have a couple of different databases on different networks with facilities to send email from within the Access databases.

Network A.
This database was written in Access 2007, runs under Vista Business and uses Outlook 2007.

Network B.
The database was written in Access 2003 and runs on the network using Windows XP Pro, Access 2003.
Email clients are Thunderbird 2, Outlook 2003 and Eudora email clients (Please don't ask me why).
The email facility worked perfectly to the selected, default email client. This could be Outlook, Thunderbird, Eudora, whatever.
The SendObject code was used: DoCmd.SendObject acSendNoObject, , , varEmail

On Network A the default email client was changed from Outlook 2007 to Thunderbird 2.
On Network B all computers were upgraded to Office 2007.

From that point on, on both networks, Access would ONLY work with Outlook 2007. If Thunderbird was running, Access would try to send the email, a couple of small message boxes popped up for a fraction of a second and Access would report "Not Responding". In the status line at the bottom of the Access window "Calculating..." would be displayed. Outlook could not be started until Access had been aborted.

I have read FAQ's and forums until my eyes hurt.
Does anyone have a solution?
Using an SMTP solution, whilst feasible, is not a preferred option.

 

[lameid]

On Network A the default email client was changed from Outlook 2007 to Thunderbird 2.

I do not believe it. They may be using Thnderbird 2 but it is no the default mail client if it worked with that mail client before. To set the default e-mail program go into IE and on the tools menu select internet options, switch to the programs tab and change the e-mail program. Either that or there is some thunderbird setting that prevents MAPI requests that needs to be fixed. In either case, post back what you find.

 

[lameid]

Some notes about Thunderbird MAPI support...

http://kb.mozillazine.org/MAPI_Support

I hope all this helps. What you really have is a MAPI support problem with Thunderbird.

 

[kwor]

I do not believe it."
Best to believe it. That was the first thing I checked.

"

http://kb.mozillazine.org/MAPI_Support"

I have already read that - one of the reasons "my eyes were hurting"

I realise that some programs do not like to play "fair". That is why I am asking for help in finding a solution. Thunderbird and probably other non Microsoft email clients may have problems with simple MAPI. That's life.

I am trying to gain other people's experience in trying to find a solution.