Emailing Snapshots

[MikeAngelastro]

Hi,

I need to be able to email charts. However, because the charts are subforms, they do not arrive at the destination along with the parent form.

It is posible to email subreports, but when you try to email it in a report as either RTF or HTML, only subreports that do not contain a chart arrive at the destination. Some progress but no cigar.

But when you email it as a snapshot file, the chart arrives at the destination. I do not want the user to have to select "snapshot" when selecting "Send" from the File menu. So I tried to automate the process using the SendObject method. However, this VBA command does not have a way for you to select "snaphaot" as an output format. I feel as though I'm up a creek without a paddle on this. Any ideas out there?

Mike

 

[BoroLee]

Mike,
I have used the following code :

DoCmd.SendObject acSendReport, "R_Old SC Detail Report(E-mail)", "SnapShot Format(*.snp)", RstTmp.Fields![Budget Holder].Value, , , "Budget Monitoring Reports", "Please find attached your Budget Monitoring Reports. Should you have any queries regarding these reports, please contact the appropriate officer in Finance.", False

HTH,
Lee.