using Access with Outlook and Acrobat

  • Thread starter Thread starter Pat Felice
  • Start date Start date
P

Pat Felice

Hello;

I currently have a procedure set up to send a snapshot of a

report or letter to outlook.

DoCmd.OpenReport "QUOTE LETTER", acViewPreview
DoCmd.SendObject acSendReport, "QUOTE LETTER", "SNAPSHOT FORMAT",
Me!Text10, , , "MC QUOTE - " & Me!Text13, , True
DoCmd.CLOSE acReport, "QUOTE LETTER"

it works beautifully, but they would like the report to be a PDF file,
(acrobat reader being more common)

We have the Acrobat pdf writer software installed and can create a pdf
manually, but is there a way to do the
same as above, but generating a PDF instead of a snapshot.

thanks
 
In case you haven't resolved this yet !

One solution that is straight forward :
1 - set your report to print to the pdfwriter, depending
on your printer settings it will either use the report
name as the filename (or the caption if set) or will ask
you to specify a destination manually.
2 - rename by using move file if you wish to
programatically give it a unique name
3 - create an email message using the outlook object and
attach the file you created.

It is posible for this to all occur programatically ie
unattended however when you send the message via outlook
2000-3 security warnings appear that require manual
acknowledgement.
 
Back
Top