Create temp file in users temp directory

[Adrian]

Access 2000

We currently email snapshot reports using an SMTP mailer

We want to change the SMTP mailer we use, but the one we are currently using
will generate a temporary filename in the relevant users local directory,
and the snapshot report is saved to this name before being sent as an
attachment. Something like:

strFilename = SMTPMailer.tempfilename ' for example "C:\Documents and
Settings\Adrian.Domain\Local Settings\Temp\2\TMPAE.tmp"
strFilename = Mid$(strFilename, 1, Len(strFilename) - 4) & ".snp" '
"C:\Documents and Settings\Adrian.Domain\Local Settings\Temp\2\TMPAE.snp"

DoCmd.OutputTo acOutputReport, rptToGo, acFormatSNP, strFilename, False

I would welcome any suggestions as to how to produce a temporary file name
in the users local directory such as "C:\Documents and
Settings\Adrian.Domain\Local Settings\Temp\2\TMPAE.tmp"

Thanks for any help.

Adrian

 

[Adrian]

Found answer at Dev Ashish's web site
http://www.mvps.org/access/api/api0014.htm