Image missing when Converting Access Report Into HTML

[akabir77]

Hi

I am using the following code to convert a access report into HTML format and then sending it via email.

        DoCmd.SendObject _
           acSendReport, _
           "rptQC-Div-email", _
           acFormatHTML, _
           rs!email, _
           , _
           , _
           "Subject", _
           "Message", _
           False, "C:\BGSolutions\template.html"
 

It works fine but my attachment is missing all horizontal lines and more importantly my logo. I am sending the report to my customer so the logo is very important in the report. I care less about the lines.

I used the template html (which I created from the same report by exporting and manually changed the image part which was also missing.) but still the output is the same.

Please help.

Thanks in advance.

[Rabbit]

The template is for the e-mail, not the object you send. Access Reports do not preserve images in html as you can't embed an image into an html page. If you want to preserve everything you'll have to use a snapshot.

[akabir77]

thanks

Can you tell me what do i have to do to make the snapshot?

[akabir77]

Oh never mind

Found the code

 DoCmd.OutputTo acOutputReport, "rptQC-Div-email", "SnapshotFormat(*.snp)", "C:\BGSolutions\test.snp"
 

[Rabbit]

Good luck.