Hi,
I may have a solution to an ongoing problem. I need to save a report in pdf. I found the great free program that prints to pdf using it as the default printer in windows.
It prompts me to save the document when I print to this printer. SO, I need some vba that will print to the default printer and then save like this, but of course not in rtf.
DoCmd.OpenForm "Main Lead Console", acNormal, "SCEmail", "", , acHidden
DoCmd.OutputTo acOutputReport, "EPackage", acFormatRTF, "C:\MyDebtIQ\Packages\" & Forms![Main Lead Console].[qlast] & "_" & Forms![Main Lead Console].[qfirst] & "_" & Forms![Main Lead Console].[ClientID] & ".rtf"
Thanks!
Ebiz
I may have a solution to an ongoing problem. I need to save a report in pdf. I found the great free program that prints to pdf using it as the default printer in windows.
It prompts me to save the document when I print to this printer. SO, I need some vba that will print to the default printer and then save like this, but of course not in rtf.
DoCmd.OpenForm "Main Lead Console", acNormal, "SCEmail", "", , acHidden
DoCmd.OutputTo acOutputReport, "EPackage", acFormatRTF, "C:\MyDebtIQ\Packages\" & Forms![Main Lead Console].[qlast] & "_" & Forms![Main Lead Console].[qfirst] & "_" & Forms![Main Lead Console].[ClientID] & ".rtf"
Thanks!
Ebiz