Name correctly the attachments

[myhnews]

I'm currently using

DoCmd.SendObject acSendReport, "rptInvoice", acFormatSNP,
stemail, , , "OrderId ID# " & txtorderNo, strBody

How can I manage to have the name of the attachment should be the
orderNo, not the default report name?

Thank you
Joe

 

[sudhirhinduja]

Naming attachments

Hi, I'm also stuck with the same problem.
Solutions suggest renaming the caption of the report.
I'm not able to get it work though.
Any inputs highly appreciated.
Thanks,
Sudhir.

 

[MicroE]

If you are using Outlook to send, check out:
http://www.myaccesstips.com/SearchDetails.asp?TipID=7

Replace "\Report.snp" with:
me.txtorderNo & “.snp”

And .To = email@mydomain.com with
.To = stemail

 

[sudhirhinduja]

Thanks

Thanks MicroE,
I totally used you're concept.
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
DoCmd.CopyObject , "rptOrder" & [InputID], acReport, "rptOrder"
stDocName = "rptOrder" & [InputID]
DoCmd.SendObject acReport, stDocName, acFormatRTF, "sudspark@gmail.com", "", , "New JDA Order", "New JDA Order"

That was a huge help!

 

[MicroE]

You are welcome – glad I could assist.