Solved

Snapshot Viewer

Posted on 2014-04-02
5
378 Views
Last Modified: 2014-04-22
I use the following code to attach an Access Report to an Outlook Email:

DoCmd.SendObject acSendReport, "ReportName", "SNAPSHOT FORMAT", strEmailTo, , , "Invoice " & strInvoiceNo & " for work completed " & strDateCompleted

Some of the recipients cannot open "SNAPSHOT FORMAT".  Is there a way to substitute "SNAPSHOT FORMAT" for Adobe pdf?
0
Comment
Question by:Biggles1
  • 3
  • 2
5 Comments
 
LVL 7

Expert Comment

by:jaynee
ID: 40000624
What version of Office are you using? If you have a version of Office that can save as pdf, simply use the acFormatPDF constant instead of "SNAPSHOT FORMAT" to send as a pdf.  So your code would look like this:

DoCmd.SendObject acSendReport, "ReportName", acFormatPDF, strEmailTo, , , "Invoice " & strInvoiceNo & " for work completed " & strDateCompleted

see http://accessvbaprogramming.wordpress.com/2012/10/06/sending-email-from-access-using-docmd-sendobject/
for examples.
0
 

Author Comment

by:Biggles1
ID: 40003687
This works in Access 2007 and on.  Unfortunately my current customer is using only 2003 which does NOT include acFormatPDF.

The problem which I have NOT encountered except for THIS user's mail recipient, is the inability to read "SnapShot" format.  Everyone else does.

Any idea how to make a computer read Snapshot?

THAT'S MY QUESTION.

Thanks
0
 
LVL 7

Accepted Solution

by:
jaynee earned 500 total points
ID: 40014150
Sorry Biggles1, I mis-interpreted your last sentence cos I couldn't see why you mentioned Adobe pdf otherwise.

So the problem is not with your user, but the person who is receiving the email. What version of Office does that person have installed?  If they have Office 2010 they might be in trouble - cos it has the snapshot viewer removed.

If that is the case, the recipient will need to get a viewer for snapshot files - the link is
http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=13911
quoted here:
http://answers.microsoft.com/en-us/office/forum/office_2010-access/office-2010-and-snp-files/fe67f8da-cf96-4710-95be-f006aefeae83
0
 

Author Comment

by:Biggles1
ID: 40014402
Hi Jaynee.  Not your fault.  My explanation of the problem was a bit iffy!  

Actually I had stumbled on Snapshot Viewer, and sent it to the "Recipient" of the Emails.  The problem was that sometimes (sometimes ?) installing the SV does not automatically associate .snp files with the snapshot viewer!!! What? is Microsoft flaky?

Well all is solved and I am accepting this as the solution to the problem.

Regards,

Biggles
0
 
LVL 7

Expert Comment

by:jaynee
ID: 40016182
Ah - that's kind of you to accept as an answer when you'd already sorted it - many thanks.

"Sometimes" indeed! :)
0

Featured Post

Connect further...control easier

With the ATEN CE624, you can now enjoy a high-quality visual experience powered by HDBaseT technology and the convenience of a single Cat6 cable to transmit uncompressed video with zero latency and multi-streaming for dual-view applications where remote access is required.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Meetings to discuss business process can waste time, and often do .  The meeting's dialog can get confusing when participants have different professional perspectives and backgrounds.  A jointly-developed process picture helps wade through the confu…
Online collaboration is quickly becoming embedded in the workplace, and its benefits are tangible. See what the current landscape looks like and what the future holds for collaboration tools and the future of work.
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question