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

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

"Adrian" <(E-Mail Removed)> wrote in message
news:uq%(E-Mail Removed)...
> 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
>
>
>