Where I work at we still use Access 97. Nothing I can do about that.
Anyways it appears the To: Cc: and Bcc: Line of the Docmd.SendObject have a
max string length. Only 2/3 of my concatenated string transferred into the
To: Line. I assume there is nothing I can do about it, but figured I'd ask.

On Mar 3, 3:31*pm, Apexstar <Apexs...@discussions.microsoft.com>
wrote:
> Where I work at we still use Access 97. Nothing I can do about that.
> Anyways it appears the To: Cc: and Bcc: Line of the Docmd.SendObject havea
> max string length. Only 2/3 of my concatenated string transferred into the
> To: Line. I assume there is nothing I can do about it, but figured I'd ask.

One way to get around it would be to automate Outlook and use the Bcc
and Cc properties. Dig around here or the MS website. There's bound
to be code there somewhere.

I no longer have 97 but if you look in Help it should give you the specs for
those paramaters. In version 2003, they are variants.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".


"Apexstar" wrote:

> Where I work at we still use Access 97. Nothing I can do about that.
> Anyways it appears the To: Cc: and Bcc: Line of the Docmd.SendObject have a
> max string length. Only 2/3 of my concatenated string transferred into the
> To: Line. I assume there is nothing I can do about it, but figured I'd ask.

On Mar 3, 3:31*pm, Apexstar <Apexs...@discussions.microsoft.com>
wrote:
> Where I work at we still use Access 97. Nothing I can do about that.
> Anyways it appears the To: Cc: and Bcc: Line of the Docmd.SendObject havea
> max string length. Only 2/3 of my concatenated string transferred into the
> To: Line. I assume there is nothing I can do about it, but figured I'd ask.

Could you use a mailing list created in Outlook? When I automate
Lotus Notes, I can do that. Others in the group may be able to give
more insight.

Hope this helps,
Chris M.