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...