Send Object attachment

[KMM]

I have a macro that is set up to send a report in the database to an email
list. I'd like to send the "pretty" report. The options of rtf, Excel, etc
aren't formatted as nicely. The Snapshot looked great, but when I tested it
and sent it to someone who didn't have Access, they couldn't open it. Is
there a way to have the Macro create a pdf of the report and attach that? Or
is there another option?

Thanks.

 

[Rick Brandt]

I have a macro that is set up to send a report in the database to an
email list. I'd like to send the "pretty" report. The options of rtf,
Excel, etc aren't formatted as nicely. The Snapshot looked great, but
when I tested it and sent it to someone who didn't have Access, they
couldn't open it. Is there a way to have the Macro create a pdf of the
report and attach that? Or is there another option?

Thanks.

2007 supports PDF natively (with an extra download I think), but no older
versions do. There are tools and external libraries that could be used
to generate the PDF on older versions, but then you would not be able to
use SendObject. You would also have to automate an external messaging
library like Outlook or CDO.

PDF requires a viewer (that is free) just as SNP requires a viewer (also
free). Have you tried providing a link in your Email where the free
viewer can be downloaded?

 

[KMM]

Sorry I forgot to put my version. It is 2003, so it looks like I'll have to
use a work around.

I know Reader is the viewer for pdf, what is the viewer for SNP? I assumed
it was tied into Access.

THanks for the response. Bummer there isn't a way to use pdf.

 

[Douglas J. Steele]

Stephen Lebans has a free sample of how to create PDF reports from Access
2003 and earlier at http://www.lebans.com/reporttopdf.htm

The free Snapshot Viewer is available at
http://www.microsoft.com/downloads/...3F-6D74-423D-8274-8B7E6313EDFB&displaylang=en