Email help. Convert to PDF.

[travismp]

Access 2000.

Here is my VB thus far.

Option Compare Database

Private Sub cmdBUTTON_Click()
Dim sSubject As String
Dim stMail As String
Dim sDocName As String

sDocName = "rep_CLIENTS"
'message subject
sSubject = "Here is your bill. Thank you. dated " & Date
stMail = DLookup("[ClientEmail]", "tbl_CLIENTS", "[ClientID]= Forms![frm_CLIENTS]![ClientID]")

DoCmd.RunCommand acCmdSaveRecord
DoCmd.SendObject acSendReport, sDocName, acFormatPDF, _
stMail, , , sSubject, "Client Billing for Today", True

End Sub

Everything work great EXCEPT the PDF part. When I click my button the send box will open and ask me to select the format which I want to send the attachment

here are my choices:
Rich Text
Excel 97-2003
Text
Excel 5-7
HTML
Snapshop

Why can it not convert to PDF on the fly? Is there anything I can install of tell Access to allow a plug in of sorts? I have Adobe Acrobat Professional installed now. thanks.

 

[dkinley]

I am pretty sure it can be done but I've never had a need to do this so can't give you an relative experience.

However, here are some links that either describe it, or get real close that you might be able to cobble together a solution ....

http://techrepublic.com.com/5208-6230-0.html?forumID=101&threadID=204959&start=0

http://www.tek-tips.com/viewthread.cfm?qid=1084512&page=1

This link is from the last link (last post on the page) that has some code in it ...

http://www.tek-tips.com/viewthread.cfm?qid=1119207&page=1

Since one of those said he did before with Acro 6, you might be able to e-mail directly and inquire.

-dK

 

[pbaldy]

I use this:

http://www.lebans.com/reporttopdf.htm

 

[dkinley]

Awesomeness.