I finally have a handle on docmd.sendobject to send e-mail. Next problem. Every time I use the line:
DoCmd.SendObject acSendReport, "rptInvoice", "Snapshot Format", strName, , , strMessage, , False
my customer receives a e-mail with rptInvoice.snp What do you do if you want to send him multiiple invoices? I tried:
strDocName = "D:\Invoice" & strInvoiceUID & ".snp"
DoCmd.OutputTo acOutputReport, "rptInvoice, "Snapshot Format", strDocName
DoCmd.SendObject acReport, strDocName, "Snapshot Format", strName, , , strMessage, , False
But acReport is wrong. What is the correct way to "sendobject" and its already a .snp?
Thanks- Ken.