Retain Report format when e-mailing.

[LEXCERM]

Afternoon all,

I have a report which has a bit of formatting in it, i.e. shaded boxes, logo etc., to make it look presentable. My objective is to e-mail the report whilst retaining the existing format.

I have started to venture into sendobjects and have tried using several of the output formats that are available, i.e. acFormatDAP, acFormatHTML , acFormatRTF, acFormatTXT, acFormatXL, but to no avail.

Is there any way that I can achieve this?

Thanks in advance.
LEXCERM.

 

[___]

You could mail it as a snapshot but the recipient must also have the snapshot viewer installed.

It can be downloaded here.

Your code would look something like this

DoCmd.OutputTo acOutputReport, "YourReport", "snapshotformat", "C:\Temp\YourReport.snp", False

to output the report to your HDD
HTH

 

[LEXCERM]

Thanks for the quick response.

Can you explain how I would e-mail it as a snapshot please.

Is it part of the sendobject command?

Not sure.

Thanks.

 

[LEXCERM]

Thanks for the code. WIll give it a go.

Cheers.

 

[___]

DoCmd.SendObject acSendReport, "YourReport", "snapshotformat", "To", "Cc", "Bcc", "Subject", "Message", True

HTH