I have the following code to send an email along with an attachment;
stDocName = "Buyers Confirmation"
DoCmd.SendObject acReport, stDocName, "PDFFormat(*.pdf)", Me.txtBuyerEmail, DLookup("[ConfirmationCCemailAddress]", "tblXYZcompanyInformation"), , "Buyer's Confirmation -- XYZ Transaction #" & Me.txtDealID, DLookup("[ConfirmationEmailBodyText]", "tblXYZcompanyInformation")
But I want the attachment to be named like this:
Buyers Confirmation XYZ Transaction 1234 (1234 is the me.txtDealID)
instead of this:
Buyers Confirmation.pdf
What do I change the code to be?
Our community of experts have been thoroughly vetted for their expertise and industry experience.
The Distinguished Expert awards are presented to the top veteran and rookie experts to earn the most points in the top 50 topics.