Solved

Snapshot Viewer

Posted on 2014-04-02
5
382 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Outlook 2013 missing emails 3 42
Word Mac 2011: Unlinking prior section from Table of Contents 5 122
Best free Visio Editor? 2 236
Grouping Slicers - excel 3 42
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…
Messaging apps are amazing tools with the power to do a lot of good, but the truth is the process of collaborating with coworkers requires relationships established through meaningful communication - the kind of communication that only happens face-…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
XMind Plus helps organize all details/aspects of any project from large to small in an orderly and concise manner. If you are working on a complex project, use this micro tutorial to show you how to make a basic flow chart. The software is free when…

733 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