TudorSmith
Programmer
Access version 97
Crystal Version 9
What I have is an Access database that generates a report for a procurement order. What is needed is for an email to be generated (that bit is working fine)
and for the procurement report to be attached as a PDF file to the email.
Now, I have the report both as a Access report and as a Crystal Report (both interrogate the same stored procedure in an SQL Server 2000 DB)
Is it possible in VBA Code, to call the Crystal report, convert it to a PDF file...save it to a location, then generate the email and attach the PDF file accordingly.
Alternatively, is it possible to convert the Access report to a PDF file instead of the Crystal report?
Tudor
birklea ~©¿©~ <><
Dim objJedi as Jedi.Knight
Set objJedi[skyWalker].Aniken = FatherOf(useThe.Force(objJedi[skyWalker].luke))
Crystal Version 9
What I have is an Access database that generates a report for a procurement order. What is needed is for an email to be generated (that bit is working fine)
and for the procurement report to be attached as a PDF file to the email.
Now, I have the report both as a Access report and as a Crystal Report (both interrogate the same stored procedure in an SQL Server 2000 DB)
Is it possible in VBA Code, to call the Crystal report, convert it to a PDF file...save it to a location, then generate the email and attach the PDF file accordingly.
Alternatively, is it possible to convert the Access report to a PDF file instead of the Crystal report?
Tudor
birklea ~©¿©~ <><
Dim objJedi as Jedi.Knight
Set objJedi[skyWalker].Aniken = FatherOf(useThe.Force(objJedi[skyWalker].luke))
