Access 2003 and SendObject and/or OutputTo

[Ken OHanlon]

I have an Access 2003 question. It is about using SendObject and/or OutputTo. I want to be able to send an e-mail (Invoice) to my customer each and every time one of his employees comes into the store and purchases something. The problem is that each time SendObject sends this e-mail (Invoice) the attached file is always the same name (the name of the report, i.e. “rptInvoice” + .snp) I want the attached filename to be “Invoice” + strInvoiceNo + .snp SendObject will not allow me to select the out going e-mails attached filename.
I tried using OutputTo which allows me to select my filename when the .snp is saved to the hard drive, but I can’t figure out how to get SendObect to then get it out the door!

Thanks- Ken.

[nspader]

Ken,

I believe that portion needs to be setup in the report page itself. Within Properties under Caption setting. I am working with Access 2000 so I am not sure if it is still the same, but worth a shot. I know that is where it worked for me.

Nick

[Ken OHanlon]

Ken,

I believe that portion needs to be setup in the report page itself. Within Properties under Caption setting. I am working with Access 2000 so I am not sure if it is still the same, but worth a shot. I know that is where it worked for me.

Nick

You are right, because I did not put a caption on the Report(rptInvoi ce), Access used rptInvoice. The question now is how can you easyly change the caption of the report(rptInvoi ce) from "Invoice 101" to "Invoice 102" in vb before using sendobject?

[nspader]

You are right, because I did not put a caption on the Report(rptInvoi ce), Access used rptInvoice. The question now is how can you easyly change the caption of the report(rptInvoi ce) from "Invoice 101" to "Invoice 102" in vb before using sendobject?

I would set up the 101 and 102 in the form you send object from and then in report caption link it to that field... "Report" & [forms]![something]![somethingelse]. Something like that should work.

GoodLuck

Nick

[Ken OHanlon]

Hi Nick. Thanks, that works perfectly. Ken.