I have situation if you could solve this also. I have following code it works fine. Only thing I want to add date to my object.
DoCmd.SendObject acSendQuery, "VdrDeliveredtoDock" & Format(Date, "MMM-DD-YYYY") & ".xlsx", acFormatXLSX, "abc@gmail.com, xyz@yahoo.com, "Dry Vendor delivered to DOCK", "Good Morning," & vbNewLine & "Attached please find the subject report." & vbNewLine & "Thanks,"
It attach my query as excel file in my outlook but want to add date to my object. Is it possible ?
DoCmd.SendObject acSendQuery, "VdrDeliveredtoDock" & Format(Date, "MMM-DD-YYYY") & ".xlsx", acFormatXLSX, "abc@gmail.com, xyz@yahoo.com, "Dry Vendor delivered to DOCK", "Good Morning," & vbNewLine & "Attached please find the subject report." & vbNewLine & "Thanks,"
It attach my query as excel file in my outlook but want to add date to my object. Is it possible ?