Stuart McLachlan
stuart at lexacorp.com.pg
Thu Apr 16 15:53:46 CDT 2009
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:\MyDummyBl 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. >