Rename a snp file

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

snapshot or pdf 7
PDF and SNP files 2
Access 2003 - Macro Output File with current date 2
saving a report as SNP 3
Print a Snp File 1
Print Snap (.snp) file later 3
Access 2003 returns an error when OutputTo creates a SNP file 1
Email Report - PDF not SNP - Need Help 2

Top