OutputTo formats question

[smdemo]

I currently have code that will email a report via Lotus Notes with an RTF format, but for a new report I have (includes lines and charts) I need to save the report as a snp or pdf. Is there any way to have the report save as a snp or pdf through the OutputTo action?

Thanks
Steve

 

[traingamer]

Just change the OutputFormat parameter to the appropriate type. (Types are listed in the help files.)

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill

 

[smdemo]

Neither of those are listed as an option. Do I need to be using another method instead or is it just not possible?

 

[traingamer]

AcFormat can be one of these AcFormat constants. 
acFormatASP 
acFormatDAP 
acFormatHTML 
acFormatIIS 
acFormatRTF 
[b]acFormatSNP[/b]
acFormatTXT 
acFormatXLS

PDFs are not one of the default formats, but snapshots are.

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill

 

[cchristi]

That's what I need today - saving my report to .pdf. I send/save Excel wkbks in Adobe, but can't figure out why the same 'OutputTo' won't work thru Access. The OutputFormat to use is acFormatRTF.

Oddly enough, the next part of the code is DoCmd.PrintOut. The prompt for a file name comes up, then saves the file as PDF. Needless to say, it needs to be automated.

Someone - help