By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,061 Members | 1,523 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,061 IT Pros & Developers. It's quick & easy.

Image missing when Converting Access Report Into HTML

akabir77
P: 5
Hi

I am using the following code to convert a access report into HTML format and then sending it via email.
Expand|Select|Wrap|Line Numbers
  1.         DoCmd.SendObject _
  2.            acSendReport, _
  3.            "rptQC-Div-email", _
  4.            acFormatHTML, _
  5.            rs!email, _
  6.            , _
  7.            , _
  8.            "Subject", _
  9.            "Message", _
  10.            False, "C:\BGSolutions\template.html"
  11.  
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.
Aug 29 '07 #1
Share this Question
Share on Google+
4 Replies


Rabbit
Expert Mod 10K+
P: 12,366
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.
Aug 29 '07 #2

akabir77
P: 5
thanks

Can you tell me what do i have to do to make the snapshot?
Aug 29 '07 #3

akabir77
P: 5
Oh never mind

Found the code
Expand|Select|Wrap|Line Numbers
  1.  DoCmd.OutputTo acOutputReport, "rptQC-Div-email", "SnapshotFormat(*.snp)", "C:\BGSolutions\test.snp"
  2.  
Aug 29 '07 #4

Rabbit
Expert Mod 10K+
P: 12,366
Good luck.
Aug 29 '07 #5

Post your reply

Sign in to post your reply or Sign up for a free account.