|  | emailing reports | | |
| | | Anne |  |
|  Posted: Thu Sep 04, 2008 8:27 pm Post subject: emailing reports |  |
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?
--
Anne |
| |
| | | Jeff Boyce | |
| | Posted: Thu Sep 04, 2008 9:48 pm Post subject: Re: emailing reports | |
Anne
When you "add the command line..." to what? Where are you trying to do
this?
Regards
Jeff Boyce
Microsoft Office/Access MVP
"Anne" <Anne@discussions.microsoft.com> wrote in message
news:95C4DAF9-E59B-4546-B766-0B587E7F322C@microsoft.com...
| Quote: | 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?
--
Anne |
|
| |
| | | Anne | |
| | Posted: Fri Sep 05, 2008 2:52 pm Post subject: Re: emailing reports | |
| |  | |
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
--
Anne
"Jeff Boyce" wrote:
| Quote: | Anne
When you "add the command line..." to what? Where are you trying to do
this?
Regards
Jeff Boyce
Microsoft Office/Access MVP
"Anne" <Anne@discussions.microsoft.com> wrote in message
news:95C4DAF9-E59B-4546-B766-0B587E7F322C@microsoft.com...
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?
--
Anne
|
|
| |
| | | Tony Toews [MVP] | |
| | Posted: Fri Sep 05, 2008 8:02 pm Post subject: Re: emailing reports | |
Anne <Anne@discussions.microsoft.com> wrote:
| Quote: | 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.
LINK
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
LINK
Tony's Microsoft Access Blog - LINK |
| |
| | | Jeff Boyce | |
| | Posted: Fri Sep 05, 2008 9:42 pm Post subject: Re: emailing reports | |
| | | |
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" <Anne@discussions.microsoft.com> wrote in message
news:5556BCDA-3D5D-43B6-8DFF-E579D35C7417@microsoft.com...
| Quote: | 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
--
Anne
"Jeff Boyce" wrote:
Anne
When you "add the command line..." to what? Where are you trying to do
this?
Regards
Jeff Boyce
Microsoft Office/Access MVP
"Anne" <Anne@discussions.microsoft.com> wrote in message
news:95C4DAF9-E59B-4546-B766-0B587E7F322C@microsoft.com...
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?
--
Anne
|
|
| |
| | | Anne | |
| | Posted: Mon Sep 08, 2008 7:58 pm Post subject: Re: emailing reports | |
| | | |
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?
--
Anne
"Tony Toews [MVP]" wrote:
| Quote: | Anne <Anne@discussions.microsoft.com> wrote:
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.
LINK
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
LINK
Tony's Microsoft Access Blog - LINK
|
|
| |
| | | James A. Fortune | |
| | Posted: Tue Sep 09, 2008 3:39 pm Post subject: Re: emailing reports | |
Tony Toews [MVP] wrote:
| Quote: | 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.
LINK
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
MPAPoster@FortuneJames.com |
| |
| | | John Spencer | |
| | Posted: Tue Sep 09, 2008 4:41 pm Post subject: Re: emailing reports | |
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
James A. Fortune wrote:
| Quote: | Tony Toews [MVP] wrote:
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.
LINK
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
MPAPoster@FortuneJames.com |
|
| |
| | | Tony Toews [MVP] | |
| | Posted: Tue Sep 09, 2008 7:57 pm Post subject: Re: emailing reports | |
"James A. Fortune" <MPAPoster@FortuneJames.com> wrote:
| Quote: | 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
LINK
Tony's Microsoft Access Blog - LINK |
| |
|
|
