Make PDF Report and e-mail it

  • Thread starter Thread starter Wilson
  • Start date Start date
W

Wilson

First of all thank you in advance if you can help me with
this.

On daily basis I have to e-mail reports from Access to
different people.

Snapshot didn't work, because some of them don't know how
to view them.

So I'm trying CutePDF to convert my reports to PDF format.

It works great!, but every time I "print" a report to
CutePDF it ask me for the pdf file name.

So, if I have to send 20 reports a day, first I should
have to save one by one and then e-mail them.

Any suggestion on how can I automate pdf report to e-mail
from access. (Convert as pdf and sent automatically)


PD
I know the code to send attachments in an e-mail message
through access.
 
Hi


I'm not familiar with CutePDF. Are you printing to a CutePDF printer driver?

I'm using Acrobat PDFWriter to automate this (i.e. requires you to have the
full version of Acrobat). Essentially, I would call Acrobat functions in VBA
to control the filename and path of the pdf file containing the Access
reports. I periodically have to generate over 1000 pdf reports and email
them, so I went through what you're going through.

I would think that CutePDF has similar implementation? Where you can call
its functions to control the filename and path?
Sorry I cant be more specific...

HTH
Immanuel Sibero
 
PD:

To be able to automate CutePDF's output file, you need to purchase their
"Custom version with developer support" not the free downloadable version
which doesn't support setting the output file. If memory serves combination
is about $499 US.

There are of course other options other than Cute PDF which are quite
inexpensive and are more programable e.g. Win2PDF (www.daneprairie.com).
PDF995, pdfFactory (www.fineprint.com).

If you want an easy interface to many of the PDF drivers out there (but not
CutePDF) you might look at our PDF and Mail Library for Access with it you
can create a pdf with target output file with as little code as:

Dim objPDF as New PDFClass
Const PDFENGINE_WIN2PDF = 3
With objPDF
.ReportName = "MyOrderReport"
.ReportWhere = "[CustomerID] = " & Me!txtCustomerID
.OutputFile = "C:\some dir\some file.pdf"
.PDFEngine = PDFENGINE_WIN2PDF
.PrintImage
End With

Mailing is just about as simple
 
I've installed Win2PDF, but can't get your code to work!
I've created a command bottom and I pasted your code in
the 'On Click" even procedure, but it doesn't work.

It always shows a "User-Defined Type not defined" error.
-----Original Message-----
Click to expand...
If you want an easy interface to many of the PDF drivers out there (but not
CutePDF) you might look at our PDF and Mail Library for Access with it you
can create a pdf with target output file with as little code as:

Dim objPDF as New PDFClass
Const PDFENGINE_WIN2PDF = 3
With objPDF
.ReportName = "MyOrderReport"
.ReportWhere = "[CustomerID] = " & Me!txtCustomerID
.OutputFile = "C:\some dir\some file.pdf"
.PDFEngine = PDFENGINE_WIN2PDF
.PrintImage
End With

Mailing is just about as simple
--
Steve Arbaugh
ACG Soft
http://ourworld.compuserve.com/homepages/attac-cg

First of all thank you in advance if you can help me with
this.

On daily basis I have to e-mail reports from Access to
different people.

Snapshot didn't work, because some of them don't know how
to view them.

So I'm trying CutePDF to convert my reports to PDF format.

It works great!, but every time I "print" a report to
CutePDF it ask me for the pdf file name.

So, if I have to send 20 reports a day, first I should
have to save one by one and then e-mail them.

Any suggestion on how can I automate pdf report to e- mail
from access. (Convert as pdf and sent automatically)


PD
I know the code to send attachments in an e-mail message
through access.
Click to expand...


.
Click to expand...
 
Wilson:

The problem you are likely having is that you need to download our PDF and
Mail Library and set a reference to it in your database as discussed in the
help file for the library under installation. The code below won't work
with out it. If you need further help with that then please e-mail us
directly, off the newsgroup. (The address is in the help file and on our
web.)
--
Steve Arbaugh
ACG Soft
http://ourworld.compuserve.com/homepages/attac-cg

Wilson said:
I've installed Win2PDF, but can't get your code to work!
I've created a command bottom and I pasted your code in
the 'On Click" even procedure, but it doesn't work.

It always shows a "User-Defined Type not defined" error.
-----Original Message-----
Click to expand...
If you want an easy interface to many of the PDF drivers out there (but not
CutePDF) you might look at our PDF and Mail Library for Access with it you
can create a pdf with target output file with as little code as:

Dim objPDF as New PDFClass
Const PDFENGINE_WIN2PDF = 3
With objPDF
.ReportName = "MyOrderReport"
.ReportWhere = "[CustomerID] = " & Me!txtCustomerID
.OutputFile = "C:\some dir\some file.pdf"
.PDFEngine = PDFENGINE_WIN2PDF
.PrintImage
End With

Mailing is just about as simple
--
Steve Arbaugh
ACG Soft
http://ourworld.compuserve.com/homepages/attac-cg

First of all thank you in advance if you can help me with
this.

On daily basis I have to e-mail reports from Access to
different people.

Snapshot didn't work, because some of them don't know how
to view them.

So I'm trying CutePDF to convert my reports to PDF format.

It works great!, but every time I "print" a report to
CutePDF it ask me for the pdf file name.

So, if I have to send 20 reports a day, first I should
have to save one by one and then e-mail them.

Any suggestion on how can I automate pdf report to e- mail
from access. (Convert as pdf and sent automatically)


PD
I know the code to send attachments in an e-mail message
through access.
Click to expand...


.
Click to expand...
Click to expand...
 
We make a module for creating PDF files from Access reports and I include
an example of how to run through a recordset and create a bunch of pdf files
and then
email them to individual customers. Our example uses ASPMail (a third party
component).

I'm giving away source code at the $99.95 price if you are interested,
Mark
RPT Software
http://www.rptsoftware.com

PS: If you have a problem feel free to email me for help.
 
Thank you, it works!

Do you know if there is any way to bypass the outlook
window "Someone is accessing your address book...." and
the "Another application is trying to send e-mail on your
behalf"

-----Original Message-----
Wilson:

The problem you are likely having is that you need to download our PDF and
Mail Library and set a reference to it in your database as discussed in the
help file for the library under installation. The code below won't work
with out it. If you need further help with that then please e-mail us
directly, off the newsgroup. (The address is in the help file and on our
web.)
--
Steve Arbaugh
ACG Soft
http://ourworld.compuserve.com/homepages/attac-cg

I've installed Win2PDF, but can't get your code to work!
I've created a command bottom and I pasted your code in
the 'On Click" even procedure, but it doesn't work.

It always shows a "User-Defined Type not defined" error.
-----Original Message-----
Click to expand...
If you want an easy interface to many of the PDF
Click to expand...
drivers
out there (but not
CutePDF) you might look at our PDF and Mail Library
Click to expand...
for
Access with it you
can create a pdf with target output file with as
Click to expand...
little
code as:
Dim objPDF as New PDFClass
Const PDFENGINE_WIN2PDF = 3
With objPDF
.ReportName = "MyOrderReport"
.ReportWhere = "[CustomerID] = " & Me! txtCustomerID
.OutputFile = "C:\some dir\some file.pdf"
.PDFEngine = PDFENGINE_WIN2PDF
.PrintImage
End With

Mailing is just about as simple
--
Steve Arbaugh
ACG Soft
http://ourworld.compuserve.com/homepages/attac-cg

"Wilson" <[email protected]> wrote
Click to expand...
in
message
First of all thank you in advance if you can help me with
this.

On daily basis I have to e-mail reports from Access to
different people.

Snapshot didn't work, because some of them don't
Click to expand...
know
how
to view them.

So I'm trying CutePDF to convert my reports to PDF format.

It works great!, but every time I "print" a report to
CutePDF it ask me for the pdf file name.

So, if I have to send 20 reports a day, first I should
have to save one by one and then e-mail them.

Any suggestion on how can I automate pdf report to
Click to expand...
e-
mail
from access. (Convert as pdf and sent automatically)


PD
I know the code to send attachments in an e-mail message
through access.



.
Click to expand...
Click to expand...


.
Click to expand...
 
Wilson:

Read the help file on set up for your version of Outlook.....
--
Steve Arbaugh
ACG Soft
http://ourworld.compuserve.com/homepages/attac-cg

Wilson said:
Thank you, it works!

Do you know if there is any way to bypass the outlook
window "Someone is accessing your address book...." and
the "Another application is trying to send e-mail on your
behalf"

-----Original Message-----
Wilson:

The problem you are likely having is that you need to download our PDF and
Mail Library and set a reference to it in your database as discussed in the
help file for the library under installation. The code below won't work
with out it. If you need further help with that then please e-mail us
directly, off the newsgroup. (The address is in the help file and on our
web.)
--
Steve Arbaugh
ACG Soft
http://ourworld.compuserve.com/homepages/attac-cg

I've installed Win2PDF, but can't get your code to work!
I've created a command bottom and I pasted your code in
the 'On Click" even procedure, but it doesn't work.

It always shows a "User-Defined Type not defined" error.

-----Original Message-----

If you want an easy interface to many of the PDF drivers
out there (but not
CutePDF) you might look at our PDF and Mail Library for
Access with it you
can create a pdf with target output file with as little
code as:

Dim objPDF as New PDFClass
Const PDFENGINE_WIN2PDF = 3
With objPDF
.ReportName = "MyOrderReport"
.ReportWhere = "[CustomerID] = " & Me! txtCustomerID
.OutputFile = "C:\some dir\some file.pdf"
.PDFEngine = PDFENGINE_WIN2PDF
.PrintImage
End With

Mailing is just about as simple
--
Steve Arbaugh
ACG Soft
http://ourworld.compuserve.com/homepages/attac-cg

message
First of all thank you in advance if you can help me
with
this.

On daily basis I have to e-mail reports from Access to
different people.

Snapshot didn't work, because some of them don't know
how
to view them.

So I'm trying CutePDF to convert my reports to PDF
format.

It works great!, but every time I "print" a report to
CutePDF it ask me for the pdf file name.

So, if I have to send 20 reports a day, first I should
have to save one by one and then e-mail them.

Any suggestion on how can I automate pdf report to e-
mail
from access. (Convert as pdf and sent automatically)


PD
I know the code to send attachments in an e-mail
message
through access.



.
Click to expand...


.
Click to expand...
Click to expand...
 
Back
Top