I am producing a 500 page report from Access, one page per person, and
need to email each individual page to each person. Is this possible or
will I have to run the same report 500 times with different parameter
values? I have no idea how to do it at all so any help would be most
welcome.

Thanks
Bill

look at this:

http://files.bdmco.com/email.zip

"Bill" <bill (AT) piperb (DOT) freeserve.co.uk> wrote




----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeed.com The #1 Newsgroup Service in the World! >100,000 Newsgroups
---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =---

"kling0n" <klingon (AT) nospam (DOT) mailandnews.com> wrote

That's not what the guy asked for I'm afraid. He has asked how to send each
page of a report to seperate people.

The only way I can think is to run the report for each person seperately
(ie. run the DoCmd.SendObject command for each person).

I'd be interested in a better way too!
--
Bradley
Software Developer www.hrsystems.com.au
A Christian Response www.pastornet.net.au/response