Emails

  • Thread starter Thread starter Holger
  • Start date Start date
H

Holger

Hello,

I am trying to address an email to many users whose emails are listed in an
Access database. Ideally, the user could click a button and a new email
would be setup with all the emails listed in the "To" box of their email
program. I have found some sucess using the ShellExecute function along
with the MailTo command. The problem is that the I believe the ShellExecute
function is limited to the amount of characters it will take. I think its
1024. So the problem is that if there are 100 emails, only some of them go
through.

Does anyone know how to get around this or can suggest a different
alternative?

Thanks so much for any help.

Holger
 
I use docmd.sendobject to send emails. If the recipient list will be long,
make it a variable and define the variable before doing the sendobject
commant.

Rick B


Hello,

I am trying to address an email to many users whose emails are listed in an
Access database. Ideally, the user could click a button and a new email
would be setup with all the emails listed in the "To" box of their email
program. I have found some sucess using the ShellExecute function along
with the MailTo command. The problem is that the I believe the ShellExecute
function is limited to the amount of characters it will take. I think its
1024. So the problem is that if there are 100 emails, only some of them go
through.

Does anyone know how to get around this or can suggest a different
alternative?

Thanks so much for any help.

Holger
 
Back
Top