[AccessD] Blatt or other email

jwcolby jwcolby at colbyconsulting.com
Wed May 23 05:27:47 CDT 2012


Yes, please do.  I changed the credentials last night so I need to know that you can no longer get 
in.  ;)



John W. Colby
Colby Consulting

Reality is what refuses to go away
when you do not believe in it

On 5/23/2012 1:09 AM, Jim Lawrence wrote:
> Hi John:
>
> Thanks for posting your working results.
>
> Can I assume, given the credentials you supplied, you would like us test it
> for you? ;-)
>
> Jim
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
> Sent: Tuesday, May 22, 2012 11:33 AM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Blatt or other email
>
>
> This is the Blat initialization code in Access.
>
> strMail = strMail&  " "&  strRecipientList
>
> strMail = strMail&  " -f "&  Chr(34)&  strFrom&  Chr(34)
> strMail = strMail&  " -from "&  Chr(34)&  strFromName&  Chr(34)
> strMail = strMail&  " -org "&  Chr(34)&  "Your Organization HERE"&  Chr(34)
>
> strMail = strMail&  " -HostName "&  Chr(34)&  "HOSTPC"&  Chr(34)
> strMail = strMail&  " -x "&  Chr(34)&  "X-INFO: BLAT Message"&  Chr(34)
>
> strMail = strMail&  " -noh"
> strMail = strMail&  " -noh2"
> strMail = strMail&  " -log "&  Chr(34)&  ShortPath(CurrentProject.Path&
> "\BlatLOG.txt")&  Chr(34)
>
> 'Stop
> 'ADD YOUR SMTP SERVER IP AND USER ID AND PASSWORD HERE SO THAT THE MAIL
> ACCTUALLY SENDS.
> strMail = strMail&  " -server "&  Chr(34)&  "74.125.130.108"&  Chr(34)
> strMail = strMail&  " -port 587"
> strMail = strMail&  " -u jwcolby"
> strMail = strMail&  " -pw !mmdrnfvs12@"
> strMail = strMail&  " -try 3"
> strMail = strMail&  " -debug"
>
> 'Actual location of BLAT
> ShellWait CurrentProject.Path&  "\blat.exe"&  " - "&  strMail&  " -body "&
> Chr(34)&  strBody&
> Chr(34), vbHide
>
>
> John W. Colby
> Colby Consulting
>
> Reality is what refuses to go away
> when you do not believe in it
>
> On 5/21/2012 5:07 PM, Jim Lawrence wrote:
>> Hi John:
>>
>> First thing that must happen is that either BLAT must be in the path or
> its
>> address must be specified. (It does not use the registry as a pointer)
>>
>> Second thing, is that the computer on which it is running must have
> internet
>> capabilities and an appropriate ISP provider.
>>
>> Below is a copy of one line that I use from an overnight backup process
>> which informs me of a process failure as well as the companies manager.
>>
>> blat C:\temp\bkupfail.html -to accessd at shaw.ca -bcc dogbert at shawlink.ca
>>
>> I put the BLAT exe in the computers " C:\WINDOWS\system32 " directory so
> the
>> application is always in the path, I am sending myself a web page, called
> "
>> bkupfail.html ", listing the errors, to both myself " accessd at shaw.ca "
> and
>> to the company's manager " dogbert at shawlink.ca " (not the real name).
>>
>> Here is a slightly more complex batch I build and run from an Access DB.
>> Blat is not on the server but there is a copy on every computer as a
>> different company does this client's server management, as all the
> desktops
>> are set for continuous backup (don't look at me talk to the server
> support),
>> I push the product up into memory and set it to run five tries (It will
> keep
>> trying until it succeeds or six trys is attempted, incase multiple events
>> cause instability, attach an invoice PDF file, send the file to the client
>> and the office accountant and track the transaction through a local file
>> called "mail.log". Note: I use the ISPs mail server is "
>> shawmail.gv.shawcable.net " as I do not want the local exchange server to
>> control the output.
>>
>> "C:\Temp\PDFFiles\Blat.exe" -install shawmail.gv.shawcable.net
>> dilbertconstruction at dilbert.ca 5
>> "C:\Temp\PDFFiles\Blat.exe" C:\temp\PDFFiles\Invoices\temp.txt -subject
> "Re:
>> Invoice 1334 from Project 655" -attach
>> "C:\temp\PDFFiles\Invoices\Invoice1334.pdf" -to filbertgrape at shaw.ca -from
>> dilbertconstruction at dilbert.ca -server shawmail.gv.shawcable.net
>> "C:\Temp\PDFFiles\Blat.exe" C:\temp\PDFFiles\Invoices\temp.txt -subject
> "Re:
>> Invoice 1334 from Project 655  Duplicate copy" -attach
>> "C:\temp\PDFFiles\Invoices\Invoice1334.pdf" -to accountant at dilbert.ca
> -from
>> dilbertconstruction at dilbert.ca -log mail.log -debug -timestamp  -server
>> shawmail.gv.shawcable.net
>>
>> You can also use text files if you are sending out copies to multiple
>> addresses.
>>
>> HTH
>> Jim
>>
>> -----Original Message-----
>> From: accessd-bounces at databaseadvisors.com
>> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
>> Sent: Monday, May 21, 2012 10:39 AM
>> To: Access Developers discussion and problem solving
>> Subject: Re: [AccessD] Blatt or other email
>>
>> I am trying to use this and getting this in the blat error file:
>>
>>
>> 2012.05.21 13:33:56 (Mon)------------Start of Session-----------------
>> Blat v3.0.3 (build : May 15 2012 01:53:41)
>> 32-bit Windows, Full, Unicode
>> <<<getline<<<   220 mx.google.com ESMTP d10sm34405147anm.17
>>    >>>putline>>>   EHLO HOSTPC
>> <<<getline<<<   250-mx.google.com at your service, [97.82.234.185]
>> <<<getline<<<   250-SIZE 35882577
>> <<<getline<<<   250-8BITMIME
>> <<<getline<<<   250-STARTTLS
>> <<<getline<<<   250 ENHANCEDSTATUSCODES
>> Sending stdin.txt to MyPersonalTestAddr at gmail.com
>> Subject: testing blay
>> Login name is MyPersonalTestAddr at gmail.com
>> Try number 1 of 3.
>>    >>>putline>>>   AUTH LOGIN
>> <<<getline<<<   530 5.7.0 Must issue a STARTTLS command first.
>> d10sm34405147anm.17
>> *** Warning ***  The SMTP server does not require AUTH LOGIN.
>> *** Warning ***  Are you sure server supports AUTH?
>>    >>>putline>>>   MAIL FROM:<MyPersonalTestAddr at gmail.com>
>> <<<getline<<<   530 5.7.0 Must issue a STARTTLS command first.
>> d10sm34405147anm.17
>> *** Error ***  The SMTP server does not like the sender name.
>> *** Error ***  Have you set your mail address correctly?
>>    >>>putline>>>   QUIT
>> <<<getline<<<   221 2.0.0 closing connection d10sm34405147anm.17
>> 2012.05.21 13:34:05 (Mon)-------------End of Session------------------
>>
>> Anyone up to helping with this?
>>
>> John W. Colby
>> Colby Consulting
>>
>> Reality is what refuses to go away
>> when you do not believe in it
>>
>> On 5/21/2012 11:28 AM, David McAfee wrote:
>>> IIRC Francisco had a sample database on Roger Carlson's website.
>>>
>>>
>>> Yup, here it is
>>>
>>>
>>
> http://rogersaccesslibrary.com/forum/tapia-francisco_forum37&SID=f4eba72b-7a
>> c5-f3c2z7f1-663b8ez5-d8b496z1.html
>>>
>>>
>>>
>>> On Mon, May 21, 2012 at 6:53 AM,
>> jwcolby<jwcolby at colbyconsulting.com>wrote:
>>>
>>>> Does anyone have a "plug and play" library for an email package other
>> than
>>>> Outlook?  I need to send email with attachments.  I am hoping that
>> someone
>>>> has written a module for Access which I can just drop in, place a dll or
>>>> something in a known location and start sending email.
>>>>
>>>> --
>>>> John W. Colby
>>>> Colby Consulting
>>>>
>>>> Reality is what refuses to go away
>>>> when you do not believe in it
>>>>
>>>> --
>>>> AccessD mailing list
>>>> AccessD at databaseadvisors.com
>>>>
>>
> http://databaseadvisors.com/**mailman/listinfo/accessd<http://databaseadviso
>> rs.com/mailman/listinfo/accessd>
>>>> Website:
>> http://www.databaseadvisors.**com<http://www.databaseadvisors.com>
>>>>
>>
>



More information about the AccessD mailing list