Stuart McLachlan
stuart at lexacorp.com.pg
Thu Apr 16 16:34:07 CDT 2009
Hi Max, Modified files will be on their way in a couple of minutes. I've already replied to Lamberts concerns. There's a big different between "potentially unwanted" and "malicious". Cheers, Stuart On 16 Apr 2009 at 22:24, Max Wanadoo wrote: > 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 > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com