emailing reports

[Anne]

I have a report that I have set up to print to a pdf, I would like to
eliminate the steps of saving the file and attaching it to an email. I
would like to print to a pdf and email this report all in one command button.
When I add the command line to send an email it only lets me send it as a
snapshot or I lose the subreports that are embeded into the report. Any
suggestions?

 

[Jeff Boyce]

Anne

When you "add the command line..." to what? Where are you trying to do
this?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Anne]

I originally added a command line that automatically emailed my report. This
worked, but I only seemed to be able to email the report in snapshot format.
The folks receiving the email need to save it at the other end - it is
actually a work order request which contains client information. If I could
save the snapshot of the report at my end with a file name that corresponds
to the work order number this would work. If not they would end up receiving
multiple emails with the same file name. Next I tried a command button that
prints the report as a pdf which I can of course name and attach to an email.
I was just trying to eliminate the last step and have the pdf automatically
sent with an email.


Thanks

 

[Tony Toews [MVP]]

I have a report that I have set up to print to a pdf, I would like to
eliminate the steps of saving the file and attaching it to an email. I
would like to print to a pdf and email this report all in one command button.
When I add the command line to send an email it only lets me send it as a
snapshot or I lose the subreports that are embeded into the report. Any
suggestions?

Ahh, you want to use Lebans solution.

A2000ReportToPDF is an Access 2000 database containing a function to
convert Reports and Snapshot files to PDF documents. No PDF Printer
driver is required.
http://www.lebans.com/reporttopdf.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Jeff Boyce]

Anne

I still don't understand where, in Access, you are trying to do this.

Are you working in a form? In a report? In a table?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Anne]

Thanks Tony. I followed your link. I can't open the A2000Sna... file. It
initially opens but then gives me an read only mesage and then closes. I
have to add I'm not a programmer or advanced user. I opened other files but
I'm not sure how to install them. Selected "find program on web" selection
then I'm asked to do scans etc. I feel a little out of my depth here. Any
suggestions?

 

[James A. Fortune]

Ahh, you want to use Lebans solution.

A2000ReportToPDF is an Access 2000 database containing a function to
convert Reports and Snapshot files to PDF documents. No PDF Printer
driver is required.
http://www.lebans.com/reporttopdf.htm

Tony

Tony,

I was under the impression that Stephen Lebans' solution required the
report to be made into a snapshot file before being converted to a PDF
document. Can his solution convert a report directly without using the
snapshot file as an intermediate step? If so, that's a very impressive
improvement.

James A. Fortune
(e-mail address removed)

 

[John Spencer]

Well, I believe his solution to print a report does create a snapshot
temporarily and then uses the snapshot to create the pdf.

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

 

[Tony Toews [MVP]]

I was under the impression that Stephen Lebans' solution required the
report to be made into a snapshot file before being converted to a PDF
document. Can his solution convert a report directly without using the
snapshot file as an intermediate step? If so, that's a very impressive
improvement.

No, Lebans' solution uses a snapshot file in the middle.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/