473,327 Members | 1,967 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

Snapshot Report - attaching to e-mail

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
1 2071
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

7
by: Pat | last post by:
I would like to send the Print Preview of a MS Access form to a Snapshot file. The form contains an OLE graph. BACKGROUND A snapshot of a report is possible. If I could I would use a report to...
1
by: Wayne Aprato | last post by:
I've just spent about an hour reading posts on exporting reports as snapshots but still can't find a solution to my exact problem. If I am looking at a report in preview mode and want to click a...
1
by: Doug | last post by:
I am sending out snapshot reports and I would like to change the name given to that particular snapshot report to include a date range instead of just the report name. Is there a way to add...
9
by: bluedolphin | last post by:
Hello All: I have been brought onboard to help on a project that had some performance problems last year. I have taken some steps to address the issues in question, but a huge question mark...
1
by: Jonathan Pinto | last post by:
I was wondering if it would be possible to snapshot an access report to Outlook, and have fields come in the To: and Cc: fields, and also the subject field of the email as well. Right now, I am...
1
by: Patrick Fisher | last post by:
Hi I have menu macro that I use for reports,it includes the following lines Send Object Report Rich Text Format Access Report Here is the Report you requested No Send...
2
by: @ndy | last post by:
When i save my rapport as a snapshot it only saves the helft of the page. I have no idee why this happens. Have somebody allreadt has this problem.
3
by: DavidB | last post by:
I have a Snapshot Control in a continuous form and I want the source for the control to be different for each instance of the continuous data (based on one of the fields in the recrod source for...
4
by: Salad | last post by:
Hi: I have the following line: DoCmd.SendObject acSendReport, "TestReport", _ "SnapshotFormat (*.snp)", _ "joeblow@nowhere.com", , , "Report Test", _ "Does it open correctly?", True I have...
8
by: grant | last post by:
Hi I've copied Stephens code into my db, and can get it to work, but only on "plain Jane" reports with no images. Most of my reports has an unbound image obluect in them that I set to an...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.