Re: Emailing a Report

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
*



Gus wrote:
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
.

Relevant Pages

  • Re: Emailing a Report
    ... I have a query that looks up all the reminders based on date. ... users that appear on the report without having to type in there email address ... Private Sub Command18_Click ... I have a DB that stores user reminders. ...
    (microsoft.public.access.modulesdaovba)
  • Re: changing file name upon sending with sendobject
    ... I guess my method must not work when using SendObject to send the report, ... opposed to just opening the report using DoCmd.OpenReport. ... Private Sub Report_Activate ...
    (microsoft.public.access.modulesdaovba)
  • Re: Emailing a Report
    ... Sub LoopAgmtsSendEmail(_ ... 'pSQL -- defines the recordset to open ... I have a query that looks up all the reminders based on date. ... a report will be produced with a list of all users who have an item to be reminded of on the mentioned date. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Emailing a Report
    ... I don't think it is a problem with the report I have ... reminders, are they now both showing up on the report? ... Since the report recordset has the rest of the fields, ... > format just one email even if I have multiple reminders." ...
    (microsoft.public.access.modulesdaovba)
  • Re: Emailing a Report
    ... Just wanted to see what your input is for having the loop code to be able to only generate one email even if the user has multiple reminders. ... 'pSQL -- defines the recordset to open ... your report is attached" _ ... we need to modify the SQL to get just the criteria that is needed and sort on User_ID ...
    (microsoft.public.access.modulesdaovba)