Solved

Snapshot Viewer

Posted on 2014-04-02
5
373 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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
Ah - that's kind of you to accept as an answer when you'd already sorted it - many thanks.

"Sometimes" indeed! :)
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Lately there has been a variety of news related to U.S. employment.  Stories about worker productivity, automobile and airline unions, low employment and foreign laborers have frequented the news.  Each story has good and bad attributes we might arg…
With the internet and the ease of information transference, many professional jobs can be done anywhere today.  Why should it make a difference whether an x-ray is read in India or the United States as long as the radiologist is qualified?   Outso…
This video shows where to find templates, what they are used for, and how to create and save a custom template using Microsoft Word.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…

743 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

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now