Auto-date in the "Subject Line"

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I apologize, I previously posted this in the wrong area.

This is probably too easy. I've created a custom button that will open a new
email. I have the recipients pre-loaded and part of body filled out. This
goes to all my sales staff daily--I attach the daily sales figures. What I'd
like to do is have the subject say "Daily sales for <current date>" I want
the <current date> part to be the actual date. Can this be done? If so,
will someone help me with the syntax? Thanks in advance.
 
Try the VBA Format function. Type Format in the VBA editor and with your
cursor inside the work hit F1. The help file should load up with a
description of the arguments.

Of course, this is only relevant if you want to change the format of the
date returned by the OS. Otherwise, just use the Date keyword when creating
the string you pass to the Subject property.
 
Back
Top