Thread: Adding a date to an Access EMailDatabaseObject macro

I would like to add the day of the week and date to the subject/body of an email being sent when a command button is clicked on a form in Access 2010. How is this accomplished?

Here is a screenshot of the macro.
EMailDatabaseObject.jpg

I converted the macro to VBA, but until I become better familiar with VBA in Access, I would like to stick with macros. I did add the =NOW function to the code and it works, but it also includes the time which I do not want. Also I'm not sure how to add the day of the week.

Any help with this is appreciated.

Option Compare Database

Function mcr_EmailReport2CS()
On Error GoTo mcr_EmailReport2CS_Err

    DoCmd.SendObject acReport, "rpt_LTL Shipments for CS", "PDFFormat(*.pdf)", "email@domain.com", _
    "", "", "LTL Shipping Report ( " & Now() & " )", "Attached is the shipping report for " & Now(), True, ""

mcr_EmailReport2CS_Exit:
    Exit Function

mcr_EmailReport2CS_Err:
    MsgBox Error$
    Resume mcr_EmailReport2CS_Exit

End Function

Found answer that works in VBA which is...

& WeekdayName(Weekday(Date)) & " " & Date &

But would still like to know if this is possible in the Macro Builder in Access 2010.

Thank you very much for posting this article. Its a very useful article. We will be acquire lot of things from this site.So i want some information about this post.

Water Damage Restoration Miami

Thank you very much for posting this article. Its a very useful article. We will be acquire lot of things from this site.So i want some information about this post.

Water Damage Restoration Miami