Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Print then Save PDF Using Default Printer

Status
Not open for further replies.

ebizleads

Technical User
Sep 14, 2005
57
0
0
US
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top