PDF using VBA in MS Access

[jamie13]

Hi,
I have both windows and office XP. I have installed Adobe PDF Maker. I am trying to generate reports and use a loop to automatically send them out usually I use the following code.
DoCmd.SendObject acSendReport, "Report Name", "SnapshotFormat(*.snp)", Forms![formname]![TO].Value, , , "", "",0

Instead of generating the snapshot format I need to do it using PDF but I don't know the syntax...
If anyone can help I would greatly appreciate it.

Jamie

 

[SgtJarrow]

see faq703-2533

You can't do this using the DoCmd.SendObject code string. The FAQ above will give you the ability to save reports as PDF fiels and then you merely use DoCmd.SendObject or Automation to create and send the e-mails.

=======================================
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)

Robert L. Johnson III
CCNA, CCDA, MCSA, CNA, Net+, A+
w: rljohnso@stewart.com
h: wildmage@tampabay.rr.com