HyperlinkAddress - 255 Character limitation

  • Thread starter Thread starter MAB
  • Start date Start date
M

MAB

I am writing an application (Access97) that will take all the email
addresses from a table, concatenate them, and then use the mailto tag
to launch an email to all the members of the list.

I wrote a function MailList() which returns a 4000 character string of
180 email adresses.

I am using the following off a mouse click to send the email -
cmdSendEMail.HyperlinkAddress = "mailto: "& MailList()

This will be used by people using various email clients so I have to
use their default client and cannot assume what client they will be
using.

All is well unless my MailList() function returns more than 255
characters. Any ideas on ways around this?

Any help will be greatly appreciated.

PS - I want to send an an email that I can edit, not a sendobject
report
 
I believe Outlook Express has 456 character limit; other email clients may
have other limits of To: field.
I don't know if this limit includes CC and BCC fields, you may try.
 
Back
Top