Split Report and Email through Outlook

[soccerska]

EG- I have a report that consist of about 41 pages, each one a seperate "receipt" that usually just gets printed off as a whole and then each page is sent to their respective payees. (each page gets sent to seperate people, but is printed off as a group) Is there anyway I can send these through Outlook, each page getting a different email address to go to?

(each report page is basically just off of individual records in a table)

 

[mdthornton]

You can't break up the report as it stands. You'll have to write some VB to process each payee in turn and print a separate report for each. You'll need to know the e-mail addresses in advance obviously. You can use "sendobject" to e-mail reports via your mail application. Best Regards,
Mike