PDF and Access97 - a tough one.

  • Thread starter Thread starter Brad
  • Start date Start date
B

Brad

Thanks for taking the time to read my question.

I have several Access 97 db's and I would like to send my
reports to Adobe Acrobat Writer 5.0 and then e-mail them.

So far all I can figure out is how to change the printer
to "Acrobat PDFWriter" and then DoCmd.PrintOut
acPagesAll.

This works, but you have to go through the save dialog
box, the user can name it anything they want, then the db
would have to try to find the saved file of which it
doesn't know the name of, attach it to an e-mail and send
it. When it tries to send the e-mail, the message about
an outside program is trying to send an e-mail on your
behalf would come up, also annoying.

I'm not sure if anyone has tried this before.

Any suggestions?

Thanks again.

Brad
 
-----Original Message-----
Thanks for taking the time to read my question.

I have several Access 97 db's and I would like to send my
reports to Adobe Acrobat Writer 5.0 and then e-mail them.

So far all I can figure out is how to change the printer
to "Acrobat PDFWriter" and then DoCmd.PrintOut
acPagesAll.

This works, but you have to go through the save dialog
box, the user can name it anything they want, then the db
would have to try to find the saved file of which it
doesn't know the name of, attach it to an e-mail and send
it. When it tries to send the e-mail, the message about
an outside program is trying to send an e-mail on your
behalf would come up, also annoying.

I'm not sure if anyone has tried this before.

Any suggestions?

Thanks again.

Brad
.
Click to expand...
 
Been here done this.

You have 2 choices.

1.

There is an addin that you can BUY that will allow you to
programatically save the report to a pdf file, then you
can send it as an attachment.

This does work, but you have save the report to disk
first, then send it, then delete it(if you want to.)
And of course Buy It.

ACG Soft PDF & Mail Library for MS Access

web: http://ourworld.compuserve.com/homepages/attac-cg
e-mail: (e-mail address removed)
mail: 2869 Baylis Drive Ann Arbor, MI 48108-1705 USA

2. Use the Microsoft Snapshot Viewer

This works just like a pdf, but is part of Access.
The Snapshot Viewer is a free download from Microsoft.

See this link
http://www.microsoft.com/accessdev/articles/snapshot.htm

Example

DoCmd.SendObject acReport, rpt_Name, "SnapshotFormat
(*.snp)", ToName, CCName, BCName, SubjectStr, msgstr,
False, ""

Note you can include the link to download the snapshot
viewer in the msg string along with instructions on
downloading.

To view this attachment, you will need the Microsoft
Snapshot Viewer. If you do not already have it installed,
you can click on this link to install.

http://www.microsoft.com/downloads/details.aspx?
familyid=B73DF33F-6D74-423D-8274-
8B7E6313EDFB&displaylang=en



AD
 
Thanks for the tip!

I'll give it a try.

Brad
-----Original Message-----
Been here done this.

You have 2 choices.

1.

There is an addin that you can BUY that will allow you to
programatically save the report to a pdf file, then you
can send it as an attachment.

This does work, but you have save the report to disk
first, then send it, then delete it(if you want to.)
And of course Buy It.

ACG Soft PDF & Mail Library for MS Access

web: http://ourworld.compuserve.com/homepages/attac-cg
e-mail: (e-mail address removed)
mail: 2869 Baylis Drive Ann Arbor, MI 48108-1705 USA

2. Use the Microsoft Snapshot Viewer

This works just like a pdf, but is part of Access.
The Snapshot Viewer is a free download from Microsoft.

See this link
http://www.microsoft.com/accessdev/articles/snapshot.htm

Example

DoCmd.SendObject acReport, rpt_Name, "SnapshotFormat
(*.snp)", ToName, CCName, BCName, SubjectStr, msgstr,
False, ""

Note you can include the link to download the snapshot
viewer in the msg string along with instructions on
downloading.

To view this attachment, you will need the Microsoft
Snapshot Viewer. If you do not already have it installed,
you can click on this link to install.

http://www.microsoft.com/downloads/details.aspx?
familyid=B73DF33F-6D74-423D-8274-
8B7E6313EDFB&displaylang=en



AD

.
Click to expand...
 
The info A Dubey gave you is wrong. First of all you do not need to purchase
any addin nor do you need to use the Microsoft Snapshot viewer.
All you need is Adobe Acrobat Search www.google.com for Adobe Acrobat Access
and you will find plenty of samples.


Jose
 
I've run automation with Access and Acrobat for years.
Very straight forward. Adobe has gotten difficultwith 6,
but if you have earlier versions, it is pretty easy.
Below is info from their site, article 312906.

How to Bypass Acrobat PDFWriter's Save As Dialog Box

By default, Adobe Acrobat PDFWriter displays the Save As
dialog box each time you create a PDF file so you can
specify a name and location for it. You can disable this
dialog box for Acrobat PDFWriter 4.0 and earlier in
Windows 95, Windows 98, and Windows NT. To do so, edit
Acrobat PDFWriter's preferences in the Win.ini file
(Windows 95 and Windows 98) or the __pdf.ini file (Windows
NT with Acrobat PDFWriter 3.0x only) so that Acrobat
PDFWriter automatically names PDF files and saves them to
a specified location. You can also disable the Document
Info dialog box that appears by default. In Acrobat
PDFWriter 4.0 for Windows NT 4.0, you need to add registry
entries to disable the Save As and Document Info dialog
boxes.

Please note that you can specify only one default name and
location when you edit the preferences file --- all PDF
files you create will be saved with the same name and to
the same location. After you create each PDF file, either
rename it or move it to a different location. Otherwise,
each new PDF file you create will replace an older file.


Note: In Windows NT, editing the preferences file works
only with Acrobat PDFWriter 3.02 or earlier. Acrobat
PDFWriter 3.03 for Windows NT does not let you make
changes to its __pdf.ini file. For Acrobat PDFWriter 3.03,
you must use the Save As dialog box to specify a file name
and location for each PDF file. Acrobat PDFWriter 4.0
doesn't include a __pdf.ini file.


Acrobat PDFWriter 3.02 and Earlier

To edit Acrobat PDFWriter 3.02 and earlier's preferences
file:
1. Make a backup copy of the Win.ini file in the Windows
folder (Windows 95 or Windows 98). In Windows NT, make a
backup copy of the __pdf.ini file in the same folder as
the Acrobat PDFWriter printer driver (this is usually the
Windows\System32\Spool\Drivers\W32x86\2 folder).


Note: If you have more than one Win.ini file or __pdf.ini
file on your system, make the changes to each file. Adobe
recommends that you have only one of either file on your
system.


2. Open the original Win.ini or __pdf.ini file in a text-
editing application that can save in text-only format
(e.g., WordPad). Locate the [Acrobat PDFWriter] section of
the file. If there isn't an [Acrobat PDFWriter] section,
create one immediately after the [Ports] section.
3. To automate the naming of PDF files and disable the
Save As dialog box, type the following line and then press
Enter:


PDFFilename=[name].pdf


where [name] is the name you want to use for your PDF
files.


4. If you want to save PDF files to a specified location,
type the path to that location and then press Enter. For
example,


C:\Pdffiles\[name].pdf


5. To disable the Document Info dialog box, type the
following line and then press Enter:

bDocInfo=0

6. Save the file in text-only format.
7. Restart Windows.


Acrobat PDFWriter 4.0 in Windows 95 and Windows 98

To edit Acrobat PDFWriter 4.0's preferences file:
1. Make a backup copy of the Win.ini file in the Windows
folder.


Note: If you have more than one Win.ini file on your
system, make the changes to each file. Adobe recommends
that you have only one of either file on your system.


2. Open the original Win.ini file in a text-editing
application that can save in text-only format (e.g.,
WordPad). Locate the [Acrobat PDFWriter] section of the
file. If there isn't an [Acrobat PDFWriter] section,
create one immediately after the [Ports] section.
3. To automate the naming of PDF files and disable the
Save As dialog box, type the following line and then press
Enter:


PDFFilename=[name].pdf


where [name] is the name you want to use for your PDF
files.


4. If you want to save PDF files to a specified location,
type the path to that location and then press Enter. For
example,


C:\Pdffiles\[name].pdf


5. To disable the Document Info dialog box, type the
following line and then press Enter:

bDocInfo=0

6. Save the file in text-only format.
7. Restart Windows.


Acrobat PDFWriter 4.0 in Windows NT 4.0

To edit Acrobat PDFWriter 4.0's registry information:
1. Restart Windows and log in as Adminstrator.
2. Exit from all applications.
3. Choose Start > Run.
4. Type "regedit" in the Open text box and click OK.
5. Choose Registry > Export Registry File, specify a
location and name for a backup registry file in the Export
Registry File dialog box, and then click Save.
6. Open to the HKEY_CURRENT_USER\Software\Adobe\Acrobat
PDFWriter key (i.e., folder).
7. Right-click the Acrobat PDFWriter Key and choose New >
String Value from the pop-up menu.
8. Type "PDFFileName" for the new value.
9. Right-click the newly created string value PDFFileName
and choose Modify from the pop-up menu.
10. Type the name of the PDF file you want automatically
generated in the Value Data field, followed by an
asterisk, and then press Enter. For example,
type "Mypdf.pdf*." If you want to save the PDF files to a
specified location, type the path to that location,
followed by an asterisk. For example,
type "C:\MyPDFFiles\Mypdf.pdf*."


Note: If an asterisk is not added to the end of the file
name, Acrobat PDFWriter will delete the string value after
using it.


11. Right-click the Acrobat PDFWriter Key and choose New >
String Value from the pop-up menu.
12. Type "bDocInfo" for the new value.
13. Right-click the newly created string value PDFFileName
and choose Modify from the pop-up menu.
14. Type "0" (zero) in the Value Data field, and then
press Enter.
15. Exit from the Registry Editor. (Your changes will be
saved automatically.)
 
Back
Top