Coding Help - Email Reports

slifer666

Master Duelist
Local time
Today, 11:18
Joined
Oct 20, 2005
Messages
25
Code:
 Private Sub cmdEmail_Click()
On Error GoTo Err_cmdEmail_Click

    Dim strDocName As String
    Dim strEmail As String
    Dim strMailSubject As String
    Dim strMsg As String

    strDocName = Me.lstRpt
    strEmail = Me.txtSelected & vbNullString
    strMailSubject = Me.txtMailSubject & vbNullString
    strMsg = Me.txtMsg & vbNullString & vbCrLf & vbCrLf & "Your Name" & _
        vbCrLf & "MailTo:youremail@nowhere.com"
    
    DoCmd.SendObject objecttype:=acSendReport, _
        ObjectName:=strDocName, outputformat:=acFormatHTML, _
        To:=strEmail, Subject:=strMailSubject, MessageText:=strMsg

Exit_cmdEmail_Click:
    Exit Sub

Err_cmdEmail_Click:
    MsgBox Err.Description
    Resume Exit_cmdEmail_Click
    
End Sub


Right, i have this code that i got off of someone on this board, and i want to modify it so that instead of it converting each page of the report to HTML it makes it into 1 PDF document and then allows me to email it out to people!

Can anyone help me with this? (I am using Office 2003 btw)
 

Users who are viewing this thread

Back
Top Bottom