[AccessD] A2003:Embedded Image in HTML

Hello Stu,
Thanks for the input. I didn't mean to send this to the List as I was
responding to an email direct from Darren, but Google in its infinite wisdom
decided to do so!  Anyway I am glad I did because you picked up on some
great points.

I wanted all the installation stuff to come via the Access program but
obviously missed that bit - not a bad job though - eh?

Any possibility of you making the changes and sending me them as a zipped
mdb (without the extn of .zip so that Google lets it through).

I have just read Lamberts posting about malware, but I have been using this
for some months now and have had absolutely no problem with it and it has
not been reported via SpyBot Search & Destroy, AVG Enterprise editi0n,
Adware or others that I use from time to time.  It may be reported as a
false positive.

I will continue to use it unless somebody can demonstrate it is actually
malware - Lambert?

Max
Ps. You are quite a clever chap, you know.   I will definately buy you a
half-pint when I next visit PNG.



-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan
Sent: 16 April 2009 21:54
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] A2003:Embedded Image in HTML

Hi Max,

You're quite right, Blat is a possible solution to Darren's problem. It
takes care of all the 
nasty details which I frightened him with :-)

I've never come across miniRelay before.  I'm definitely adding that to my
toolbox.

A few of points on MyDummyEmailer:

1.  I personally don't like using Blat -install.   You can include the
Server and Sender 
address parameters in the Blat string and then you don't leave any Registry
settings floating 
around.

2.   Your BlatInstall.bat uses a domain name as the Sender address. You need
a valid 
address here, not just a domain name otherwise you will find many mail
servers rejecting 
your message. 

So: don't bother with BlatInstall.bat. Just  do something like this:

Const conBatchText As String = "C:\MyDummyBlatEmailer\blat.exe " & _
"C:\MyDummyBlatEmailer\Email.htm  " & _
" -bf C:\MyDummyBlatEmailer\sendlist.txt " & _
" -server localhost " & _
" -f stuart at lexacorp.com.pg " & _
.......

3. Now for the biggie :-(
Look at the the Subject of this thread.   The original request was how to
embed images in 
HTML formatted emails.

Your solution doesn't do that, it leaves the local directory links to the
images in the email.

For Blat to embed the files, you need to use the -embed switch, list the
files and use cid 
tags in your HTML documents.

So you need to:

a. Add another line to conBatchText:
" -embed 
C:\MyDummyBlatEmailer\Myjpg1.jpg,C:\MyDummyBlatEmailer\Myjpg2.jpg,C:\MyDummy
Bl
atEmailer\Myjpg3.jpg,C:\MyDummyBlatEmailer\Myjpg4.jpg " & _

b. Edit your  HTML document to add the "cid:" to your "img src" i.e.
<img height="100" alt="" src="cid:Myjpg4.jpg" width="150" border="0">

Note, don't include the image paths in the HTML document, just use the file
name.  Blat 
uses the paths in the -embed switch to find the data it needs.
 
Once you do the above, your Access application works as required. 
 

Cheers,
Stuart 

On 16 Apr 2009 at 13:55, Max Wanadoo wrote:

> Hi Darren,
> I have tried to strip all my stuff out of the mdb and leave behind a
"blank"
> one that you can use.
> 
> It relies on BLAT and local SMTP program - both free.
> 
> You create your own htm email and it is then sent out via the mdb which
> needs the domain details etc setting up.
> 
> Download the mdb from here:-
> 
> www.peoplelinks.co.uk/msaccess/downloads/MyDummyBlatEmailer.zip
> 
> Let me know how you get on.  This DOES work and very successfully.
> 

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com