Save reports as unique files

  • Thread starter Thread starter Bobk
  • Start date Start date
B

Bobk

I have the task of generating a monthly vendor report which consists of bar
charts showing quality and ontime ratings. I have suceeded in automatically
printing the charts for each vendor, but I would like to save the charts and
ultimately convert them to pdf's. I want to automatically save each chart by
vendor number. I am currently able to generate the charts using:
DoCmd.OpenReport "rptReportCard", acViewNormal
This ends up printing a hardcopy which gets mailed to the vendor. I want to
change this to where I automatically name each chart by vendor number and
save it and then email or fax it to my vendors. Is there a way to do this?
Can I do an automatic "save as" naming each chart with the corresponding
vendor number?
 
Thanks for the input.

I have discovered another way to do what I wanted to do. The
"DoCmd.OutputTo" will work. I wrote the following code which sends the
report "rptReportCard" to the folder "VRC-TEST" in My Documents. It is
renamed to the customer number held in Qvendnomdonly and formatted to SNP.

DoCmd.OutputTo acOutputReport, "rptReportCard",acFormatSNP,
"C:\DOCUMENTS AND SETTINGS\user\My Documents\VRC-TEST\" & Me.Qvendnomdonly
& ".snp", False

Now, if I can get the report formatted to PDF and then save and email or fax
automatically I will have totally automated the process.
 
Back
Top