Email Individual Pages of a report?

[Gin_bee]

Small Query!

I'm using Crystal Reports 9 with VB6 and was wondering if it is possible to email individual pages of a report to different people..

Each page of my report produces information about a single person, I would like to be able to email each person a copy of their own report but not send the entire report to them. I want each page of the report to go to the person whose detais are listed on that page.

Any Help would be greatly appreciated

[brucevde]

Hopefully I can explain this properly. I do something similar, so I should be able to help. First some questions.

You are trying to do this in VB right?

What are you using for email? Are you going through an MS Exchange server.

Does your report contain at least one Group? It would make things easier if the top level group is based on the person who gets the email. Also, the name of the person matches their email address (or as long as the email address can be determined from the persons name).

I won't go further until you reply but basically, as the report is being generated, you need to capture some of the events raised in a class module and process accordingly.

Also, I don't use Crystal 9 but 8.5. Hopefully, things are still the same.

[Gin_bee]

BruceVDE

I'm using VB.6 and trying to use an MS exchange server

Currently the report has a number of different groups one of which contains all the identifer information for an individual person. I have peoples email addresses and these are returned by the query used against the report, not possible to determine an email from the given name.

Thanks.