Ahhh - i have found that it is as simple as adding
CrystalReport.PrintFileType = crptRTF ' Or xls etc - But No pdf option available
CrystalReport.Destination = crptMapi ' Or crptExchange
CrystalReport.PrintReport ' Or CrystalReport.Action = 1 does the same
So now I can send my report as an attachment to an email, and so simply.
Only two problems left
1) I think this method only works with crystal report version 8.5 or less. Is there an equivalent for version 9,10,11? Everything Ive looked at so far is really complicated.
2) How to send the report as a pdf? Can this be added as an option somehow?
Probably, you'll want to add a PDF print driver, print to a file, then, email the resulting file as an attachment. The Ostrosoft SMTP component works well for this.
"Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
"I have my standards. They may be low, but I have them!" - Bette Middler
"It's a book about a Spanish guy named Manual. You should read it." - Dilbert