• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 395
  • Last Modified:

Snapshot Viewer

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
Biggles1
Asked:
Biggles1
  • 3
  • 2
1 Solution
 
jayneeIT ManagerCommented:
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
 
Biggles1Author Commented:
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
 
jayneeIT ManagerCommented:
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
 
Biggles1Author Commented:
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
 
jayneeIT ManagerCommented:
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: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

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

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now