Adding a date variable as subject

[ChristopherL]

Hi,
I am using a EmailDatabaseObject to send out a report for my job.
I want to add a date variable in the subject..
Is this possible?

Like

Report as of =date()

2nd. Question.. Can I attach two reports in the same mail?


Best Regards,
C

 

[bob fitz]

I think you can use something like:
= "Report as of " & Date()
as the Control Source property of a text box on a report.

 

[ChristopherL]

I think you can use something like:
= "Report as of " & Date()
as the Control Source property of a text box on a report.

Thank you, but..
How will that affect the subject of the email?

 

[bob fitz]

I'm sorry, I misunderstood your requirement.

 

[dcwaits2]

I have a batch file call my macro that runs my reports. I write my reports out to .RTF and have a third party software utility (sendEmail) do the emailing. I can attach multiple .RTFs as attachments and insert variables from the command line in the subject & Body as needed.