Re: date in subjectline for automated email

From: pietlinden@xxxxxxxxxxx
Date: 15 Sep 2006 08:53:23 -0700

Parasyke wrote:

I'm needing to place today's date in the subject line of an email using
the following example:

DoCmd.SendObject acSendReport, "This Is My Subject Line", acFormatRTF,
_

Can anyone show me how to place the date so that it reads: This Is My
Subject Line - 09/15/2006 (?)

Thanks in advance!

"Some subject - " & format(date,"mm/dd/yyyy")

read up on Format in Help. (if you're like MLH, it's carefully hidden
under the F1 key)

.

References:
- date in subjectline for automated email
  - From: Parasyke

Prev by Date: O.T. I deleted everything in c:\ ... Content.IE5
Next by Date: Re: O.T. I deleted everything in c:\ ... Content.IE5
Previous by thread: date in subjectline for automated email
Next by thread: O.T. I deleted everything in c:\ ... Content.IE5
Index(es):
- Date
- Thread

Relevant Pages

Re: Access 2003 and Emailing via Outlook
... DoCmd.SendObject acSendTable, "Employees", acFormatRTF, myemail@myemail.com, ... > DoCmd.SendObject acSendReport,, acFormatRTF, response ... > EditMessage parameter ... > For more information on SendObject method, ...
(microsoft.public.access.formscoding)
Re: DoCmd.OutputTo
... To send a report, use this command: ... DoCmd.SendObject acSendReport, strReportname, acFormatRTF, strRecipient, ... The string variables can be populated however you want, either from the db, ...
(microsoft.public.access.modulesdaovba)
Re: Error emailing Excel attachment
... On Jul 20, 9:52 am, Stephanie ... When send an email with at RTF attachment, ... DoCmd.SendObject acSendReport, "Member List", acFormatRTF, Me.EmailName,, ...
(microsoft.public.access.formscoding)
Re: E-Mail Problem
... A2000, Win98, Opera 7.23, ... DoCmd.SendObject acSendReport, rpt, acFormatRTF, adresse ... Gruss ...
(microsoft.public.de.access)