I have some simple code behind a control button - basically prints a report
and send the report (in snapshot format) to lotus notes for e-mailing.

The code worked fine for ages and all of a sudden the attachment to Lotus
Notes has an *.xls extension and not a *snp extension. I haven't done
anything to my PC it just happened!!

The "fix" is to copy the attachment to my desctop, rename it with the
correct extension (.snp) and re attach it to the e-mail.

Has anyone ever come accross this - or does anyone know how to fix it?

I'm using W2K, A2002 and Lotus Notes v6

The code I'm using is: -

Private Sub Command72_Click()
On Error GoTo Err_Command72_Click

   Dim stDocName As String
   Dim strReportFilter As String

   If Not IsNull(Me![cellnum]) Then
   DoCmd.Save

   Else
   MsgBox "You must enter a Cell Number", vbOKOnly, "Cell"

   Exit Sub
End If

   stDocName = "RptDeliveryDetails"
   strReportFilter = "ID = Forms!FrmMainEntry!ID"
   DoCmd.OpenReport stDocName, acViewNormal, , strReportFilter
   DoCmd.SendObject acSendReport, stDocName, acFormatSNP,
"emailaddress.com.au", , , "email subject", "Please look at the attachment",
True

   ConfirmStore = Now()

Exit_Command72_Click:
   Exit Sub

Err_Command72_Click:
   MsgBox Err.Description
   Resume Exit_Command72_Click

End Sub