Auto add of date to Subject field when sending email

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • jerry.ranch@pioneer.com
    #1

    Auto add of date to Subject field when sending email

    I have a macro that autoruns once weekly and sends an email with an
    attached xls file ( a data extract) to some internal customers.

    The subject always reads [Mr X Update], for example...is there a way
    to add a date into the subject field based on system date like

    Subject: [Mr X Update] 06/17/2006


    Thanks
    Jerry
    Tags: None
    • Jeff L
      #2
      Re: Auto add of date to Subject field when sending email

      [Mr X Update] & " " & Date()

        Comment

        • jerry.ranch@pioneer.com
          #3
          Re: Auto add of date to Subject field when sending email

          Nope
          Didn't work
          All I get is the text as written below
          Jerry


          On 22 Jun 2006 12:24:34 -0700, "Jeff L" <jleckrone@hotm ail.com> wrote:
          [color=blue]
          >[Mr X Update] & " " & Date()[/color]

            Comment

            • Rick Brandt
              #4
              Re: Auto add of date to Subject field when sending email

              jerry.ranch@pio neer.com wrote:[color=blue]
              > Nope
              > Didn't work
              > All I get is the text as written below
              > Jerry
              >
              >
              > On 22 Jun 2006 12:24:34 -0700, "Jeff L" <jleckrone@hotm ail.com> wrote:
              >[color=green]
              >> [Mr X Update] & " " & Date()[/color][/color]

              Do you have the whole thing surrounded by quotes? (shouldn't be)

              Post your code.

              --
              Rick Brandt, Microsoft Access MVP
              Email (as appropriate) to...
              RBrandt at Hunter dot com


                Comment

                • jerry.ranch@pioneer.com
                  #5
                  Re: Auto add of date to Subject field when sending email

                  Made a macro

                  action is SendObject


                  in dialog box that specifies Subject I have

                  [pivot test] &" "&Date()

                  [pivot test] is NOT a database object or field, just the subject I
                  place in []

                  So I just tried this

                  ="Pivot Test"&" "&Date()

                  Now it works perfectly
                  Thanks All

                  Jerry


                  On Thu, 22 Jun 2006 20:37:50 GMT, "Rick Brandt"
                  <rickbrandt2@ho tmail.com> wrote:
                  [color=blue]
                  >jerry.ranch@pi oneer.com wrote:[color=green]
                  >> Nope
                  >> Didn't work
                  >> All I get is the text as written below
                  >> Jerry
                  >>
                  >>
                  >> On 22 Jun 2006 12:24:34 -0700, "Jeff L" <jleckrone@hotm ail.com> wrote:
                  >>[color=darkred]
                  >>> [Mr X Update] & " " & Date()[/color][/color]
                  >
                  >Do you have the whole thing surrounded by quotes? (shouldn't be)
                  >
                  >Post your code.[/color]

                    Comment

                    Previous template Next
                    Working...