Software that will Output MS Access 2003 reports as .pdf and/or email them

kalbal,

The Brevity of your question Belies it's complexity.
;-)

You must:
Have an existing Report
Select that Report
convert the report to PDF
Specify a name for the pdf
Specify a Location for the pdf.
Have a way to select the email recipient
Determine the recipients email address.
Design and interface to do all of this.

So as you can see, if you want a targeted solution, you need to have a fair amout of the above list completed.
;-)

In the most basic sense you will need a program like this to convert the report to a PDF:
http://www.cutepdf.com/,

Then use code like this to create an email and attach the pdf:

Dim objOutlook          As Outlook.Application
Dim objOutlookMsg       As Outlook.MailItem
Dim objOutlookRecip     As Outlook.Recipient
Dim objOutlookAttach    As Outlook.Attachment


' Create the Outlook session.
Set objOutlook = CreateObject("Outlook.Application")
' Create the message.
Set objOutlookMsg = objOutlook.CreateItem(olMailItem)
   
    With objOutlookMsg
        ' Add the To recipient(s) to the message. Substitute
        ' your names here.
        Set objOutlookRecip = .Recipients.Add("oops@att.net")   '<--Recipient's name or email address
        objOutlookRecip.Type = olTo
        ' Set the Subject, Body, and Importance of the message.
        .Subject = "This is an Automation test with Microsoft Outlook"
        .Body = "This is a Test Email"              '<--Email Body text.
        'Add attachments to the message.
        Set objOutlookAttach = .Attachments.Add("C:\YourFolder\PDFFile.pdf")

        ' Resolve each Recipient's name.
        For Each objOutlookRecip In .Recipients
            If Not objOutlookRecip.Resolve Then
                objOutlookMsg.Display
            End If
        Next
       
        'Send email without viewing it.
        '.Send
       
        'Dispay email before sending.
        .Display
   
    End With

'Cleanup Code
Set objOutlookMsg = Nothing
Set objOutlook = Nothing
Set objOutlookRecip = Nothing
Set objOutlookAttach = Nothing



Notes:
- You will need to set a reference to the Outlook Library in the VBA editor.
- You will need a program like (http://www.contextmagic.com/express-clickyes/) to bypass the Outlook security Pop-up in you want the emails sent automatically without viewing them.
- Outlook will probably need to be open when you run this.

So can it be done?
Yes.

Will it be easy?
Depends on what you call easy.
;-)

But this should point you in the right direction.
;-)


JeffCoachman