Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Modules / DAO / VBA / January 2007

Tip: Looking for answers? Try searching our database.

Emailing a Report

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Gus - 21 Jan 2007 15:32 GMT
Hi, Thanks for your help.

I have a DB that stores user reminders. A report has been created to get
users who need to be reminded of something they must do on a spcific date.

I am trying to formulate code to be able to send an email with the report
for the users that appear on the report. I am using Lotus Notes.

This is the code that I am  currently using.  

Private Sub Command18_Click()
DoCmd.SendObject _
   acSendReport, _
   "Daily Reminders All Teams Report", _
   acFormatRTF, _
   "UserEmail", _
   , _
   , _
   "Your Reminder", _
   "Have a good day!", _
   False

End Sub
strive4peace - 23 Jan 2007 14:20 GMT
Hi Gus

here are the parameters for SendObject

'========================================= Email
'SendObject
'[objecttype]
'[, objectname]
'[, outputformat]
'[, to]
'[, cc]
'[, bcc]
'[, subject]
'[, messagetext]
'[, editmessage]
'[, templatefile]

What is your question?

Warm Regards,
Crystal
 *
     (:  have an awesome day  :)
  *
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
  *

> Hi, Thanks for your help.
>
[quoted text clipped - 19 lines]
>
> End Sub
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.