Stuart McLachlan
stuart at lexacorp.com.pg
Thu Apr 16 16:58:52 CDT 2009
It's almost 8:00am here. I woke up about 4:00am for some reason and couldn't get back to sleep so decided to have a look at your solution. But now... I Owe, I Owe, so off to work I go....... Cheers, Stuart On 16 Apr 2009 at 22:49, Max Wanadoo wrote: > Thanks Stu, > > Either you are bored stiff or you are after that half-pint. Probably the > latter - ha! > > Will check it out tomorrow as I am about to have a wee drinky-poo and close > down for the night. > > I would like to hear from Darren to see if any of this helped him. > > Thanks mucho, my friend. > > Max > > > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan > Sent: 16 April 2009 22:34 > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] A2003:Embedded Image in HTML > > 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 > > > -- > 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