Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Sending reports via Outlook within access
- Thread starter TnE
- Start date
Do do as a macro you use SendObject and fill in the fields
Or you can use this code on a button.
Dim emailList As String
Dim subject As String
Dim messageText As String
Dim txtdate As String
emailList = "email@domain.com"
subject = "Report"
txtdate = Now()
messageText = "Report ran at " + txtdate
DoCmd.SendObject acSendReport, "Report Name", acFormatRTF, emailList, , , subject, messageText, True
Or you can use this code on a button.
Dim emailList As String
Dim subject As String
Dim messageText As String
Dim txtdate As String
emailList = "email@domain.com"
subject = "Report"
txtdate = Now()
messageText = "Report ran at " + txtdate
DoCmd.SendObject acSendReport, "Report Name", acFormatRTF, emailList, , , subject, messageText, True
- Status
Similar threads
- Locked
- Question
- Locked
- Question