ACTEBS
actebs at actebs.com.au
Fri Dec 19 10:44:33 CST 2008
Max, I forgot to say that you'll need a table in your DB that stores the settings for your Mail Server. The fields are as follows: EmailSetupID AutoNumber MailHost Text 'IP of yourSMTP Server MailSender Text 'Email Address of the Sender MailUsername Text 'SMTP Server Username MailPassword Text 'SMTP Server password AttachmentDelimiter Text 'Delimiter used for multiple attachments (I used comma ",") EmailSubject Text 'Email Subject line which I appended additional info to like an Application Number EmailDear Text 'How you want to start the email off eg Dear or Hey Shithead EmailBodyText Memo 'The actual body text. This is because I sent PDF docs which were attached EmailFooter Text 'Something like "Yours Sincerely" AttachEncoding Text 'Use base64 Regards Vlad -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of ACTEBS Sent: Saturday, 20 December 2008 3:06 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] SMTP Server Max, An SMTP Server manages the email for a domain or several domains like abc.com and xyz.com. That's why you need hMailServer. It will send out the email and receive email on your domains behalf and you pick it up from hMailServer via POP3 or via IMAP. You asked for an SMTP Server and hMailServer is exactly that... What you are trying to do is code up something so you can send email from your app to recipients based on some criteria am I right? In that case you need something like Blat and some code that will send out what you create through Blat which in turn sends it through your SMTP server. I have created a little example for you from an app I did a few years ago that works very well and does exactly what you need. Inside this zip file you'll find everything you need to create a solution from the documentation for Blat to the module I created to create the emails and send them out. You can download it here: http://download.actebs.com.au/blat.zip Inside the zip file you'll find a file called VladsEmailCode.txt which is the module you will need to research to get an understanding of how I went about it. You will also need to read the items in the docs folder to understand how to use Blat. Good luck, and if you need some more help get back to me... Regards Vlad -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Max Wanadoo Sent: Saturday, 20 December 2008 2:19 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] SMTP Server Thanks Vlad, I cannot see to get it to work using an MS Access. It wants to install with MySql or Sql Server. Is there a workaround that you know off perhaps? Thanks Max On Fri, Dec 19, 2008 at 2:48 PM, ACTEBS <actebs at actebs.com.au> wrote: > Max, > > Try this: > > http://www.hmailserver.com/ > > It's brilliant, I've been using it for years... > > Vlad > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Max Wanadoo > Sent: Saturday, 20 December 2008 1:34 AM > To: Access Developers discussion and problem solving > Subject: [AccessD] SMTP Server > > Hi Guys, > Does anybody have any Access Code to provide the same functionality as > a SMTP server > > or alternatively any FREE SMTP Server software. > > All the ones I have found are crippled in some way or another with an > invite to purchase the full blown one as xyz£$. > Thanks > Max > -- > 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