Save reports sent out (1 Viewer)

[cktcPeterson]

I have students who have applied for scholarships. When we send an approval letter, is there a way save it under their profile? Maybe a macro that uploads it as an attachment? Or any other ideas?

 

[Eugene-LS]

save it under their profile?

I'm sorry, I don't understand your question.
What did you mean by "save it under their profile?"

 

[gemma-the-husky]

You would be best generating a disk file, pdf, and storing a link to that file.

 

[The_Doc_Man]

In order to answer that question, we need to know your environment.

For example, IF you were talking about Office and the Outlook environment, then each user has a profile file that retains sent messages (at least for a while). You can move a message from SENT to a private profile folder that Outlook wouldn't touch.

If Outlook isn't in the picture then some other assumptions are involved. Which is why we need to know your environment.

 

[Eugene-LS]

Maybe a macro that uploads it as an attachment?

'Saving a report to PDF
Dim sPath$
    sPath = "D:\temp\Report_01.pdf"
    DoCmd.OpenReport "DataTest", acViewPreview, , "RecIDAuto=1", acHidden
    DoCmd.OutputTo acOutputReport, "DataTest", acFormatPDF, sPath, False
    DoCmd.Close acReport, "DataTest"

Or this way:

Dim sReportName$, sFilePath$
'Saving a report to PDF..
    sReportName = "Report Name"
    sFilePath = "D:\temp\ppt0000456.pdf"   
    DoCmd.OutputTo acOutputReport, sReportName, acFormatPDF, sFilePath, False
    MsgBox "File saved as: " & vbNewLine & sFilePath, vbInformation, "Report Exported as PDF"