Exporting Report Question..??

[WB786]

I am exporting a report to be emailed and using the acFormatSNP which works fine except that for the attachment name it says qry_ReportName.SNP. How could I make it so that the report attachement name could be little bit more meaningful for my client. I don't want the name to say qry_. Anyone has any idea on this??? Thanks in advance.

WB

 

[PaulBricker]

What method are you using to Export it? Do you have the code you can post.

Paul

 

[WB786]

Here is the coding for my on click event button.

Dim stDocName As String

stDocName = "SPLetter"
DoCmd.SendObject acReport, stDocName, acFormatSNP, , , , "Your Account Information."

 

[WB786]

Ok nevermind, figured it out. Name the report correctly in the properties. My brian was on a long break from programming. Thanks for replying though.

WB