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
--
John Taylor