PDF and Access97 - a tough one.
From: A Dubey (adubey_at_winstead.com)
Date: 04/02/04
- Next message: A Dubey: "Using Form Name as Varible"
- Previous message: Chris: "Weird collection processing results - needs an expert"
- In reply to: Brad: "PDF and Access97 - a tough one."
- Next in thread: Brad: "PDF and Access97 - a tough one."
- Reply: Brad: "PDF and Access97 - a tough one."
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 2 Apr 2004 15:29:32 -0800
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: 75323.2112@compuserve.com
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
>-----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
>.
>
- Next message: A Dubey: "Using Form Name as Varible"
- Previous message: Chris: "Weird collection processing results - needs an expert"
- In reply to: Brad: "PDF and Access97 - a tough one."
- Next in thread: Brad: "PDF and Access97 - a tough one."
- Reply: Brad: "PDF and Access97 - a tough one."
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
