Send multiple documents to multiple email addresses

[waldridge]

I've got a vendor's report that needs to be sent to the email addresses in
their particular report. I'm using the SendObject command but it only picks
up the first email address on the first page of the report. Each page needs
to be sent to a different email address. Thanks so much.

 

[PieterLinden via AccessMonster.com]

I've got a vendor's report that needs to be sent to the email addresses in
their particular report. I'm using the SendObject command but it only picks
up the first email address on the first page of the report. Each page needs
to be sent to a different email address. Thanks so much.

short answer is that SendObject is severely limited (as you've just
discovered, no doubt!). I would check out Tony Toew's website
www.granite.ab.ca and read his e-mail FAQ and maybe Stephen Lebans' stuff on
Access - www.lebans.com. Unfortunately, Stephen has moved on to bigger and
better things...

Pieter

 

[PieterLinden via AccessMonster.com]

I've got a vendor's report that needs to be sent to the email addresses in
their particular report. I'm using the SendObject command but it only picks
up the first email address on the first page of the report. Each page needs
to be sent to a different email address. Thanks so much.

Maybe this will help:
http://www.granite.ab.ca/access/email/reporttomultiplerecipients.htm

read around... I'm pretty sure the answer is somewhere on Tony's page.