save each page of a snapshot as an individual file

A

Access Denied

Greetings!

I am working on querying data tables from my companies MRP program. I have
created a report that extracts deficiencies from the data tables. Each page
of the report contains data for each individual supplier. I am looking to
save each page of the report as an individual file so that they can be sent
to each supplier (I don't want them to see each other's data). Anyone have a
good way to do this?

Additionally, part of the extraction includes the supplier's e-mail
addresses (a field in a table). If anyone has a good idea on how to use it
to link with Outlook so that I can automate this process that would be peachy
keen.

Thanks,
 
Top