Rename a snp file

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I currently using the following code to send a snp file via e-mail. It works
fine.

DoCmd.SendObject acSendReport, "report123", acFormatSNP, "(e-mail address removed)", ,
"(e-mail address removed)", "Subject Text", "Body Text" & strIdentify

How can I change the name of the snp file with a field value? Example:
Now, the snp file shows up as an attachment and looks like report123.snp
every time.

I would like to have the prefix of the snp file use a field value. That
way, It would use the value of that field and look like 1234.snp or 1235.snp,
etc... The field I would like to use is strIdentify.

Is this possisble? Thanks.
 
Back
Top