Email Address list to Thunderbird

[nq]

I have a Microsoft Access database. There is a facility to email a list of people from the database. I read every record, put all the email addresses into a variable (varEmail) and send the variable to the Email program with this code:

DoCmd.SendObject acSendNoObject, , , varEmail

The default Email program will open and place all the addresses into the "To" line. The user may then complete the emial message and send.

This procedure works well with Outlook, Outlook Express and Eudora. However with Thunderbird, Access returns and error message that there were "Too many message recipients". There are in fact about 150 addresses. I can cut and paste the entire list into Thunderbird's address line with no problem, it just will not accept that many addresses from Access.

Any ideas?

 

[Flippertje]

Perhaps it's possible to paste this line in two parts?

 

[nq]

I think the problem is more fundamental. I can display the contents of varEmail, which contains all the addresses, and cut and paste it into Thunderbir's address line. This means that the problem is not a limitation of Thunderbird's capacity, rather a problem in transferring the data with the command:
DoCmd.SendObject acSendNoObject, , , varEmail

 

[Flippertje]

This is what i mean by sending it in two parts rather than in one (apparently too long) string..

 

[nq]

Thanks for the suggestion. Yes, it would be possible to do it in multiparts. Unfortunately the number of addresses may change. To be safe I could split it into 4 or 5 sections but the solution is not elegant. My database can already split the addresses by several areas, so the workaround is email by area rather than a complete email.

I have looked through the bugs at Mozilla and found several similar problems, so I have formally entered the problem as a bug with Mozilla and see what happens.