Solved

Snapshot Viewer

Posted on 2014-04-02
5
375 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

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

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

Outline Suppose you have some simple text based data in Excel that you would like to display as a PowerPoint presentation. Of course it would be possible to write some fairly complex VBA code that created a new slide for each line of the Excel data…
Today companies are subjected to more-and-more data, and it won't stop any time soon.  But there are obvious opportunities for reducing data, particularly data duplicated among companies.
The viewer will learn how to edit text. This includes Font, Spacing, Resizing, Color, and other special text options.
This video walks the viewer through the process of creating Hyperlinks for the web and other documents. Select the "Insert" tab: Click "Hyperlink":  Type "http://" followed by a web address to reference a website or navigate to a document to ref…

863 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

19 Experts available now in Live!

Get 1:1 Help Now