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

re: Auto add of date to Subject field when sending email

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

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@hotmail.com> wrote:
[color=blue]
>[Mr X Update] & " " & Date()[/color]

re: Auto add of date to Subject field when sending email

jerry.ranch@pioneer.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@hotmail.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

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@hotmail.com> wrote:
[color=blue]
>jerry.ranch@pioneer.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@hotmail.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]