By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,933 Members | 1,243 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,933 IT Pros & Developers. It's quick & easy.

Snapshot Report - attaching to e-mail

P: n/a
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

Apr 29 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
John Taylor wrote:
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!!

[snip]

See this Microsoft Knowledge Base article...

http://support.microsoft.com/default...b;en-us;555020
--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
Apr 29 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.