[AccessD] SendObject Attachments

Rocky Smolin at Beach Access Software rockysmolin at bchacc.com
Sat Nov 24 09:20:18 CST 2007


I like it.  I wouldn't distribute it to a lot of users, however.  In my
manufacturing system the installation is dead simple.  First instruction
-Create a folder C:\E-Z-MRP.  50% of the users were stumped.  That's when I
switched to Wise/Sagekey.

But for one-off installations it looks like a better approach.

Rocky
 




 	
	

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
max.wanadoo at gmail.com
Sent: Saturday, November 24, 2007 6:48 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] SendObject Attachments

Rocky,
The email setting are easily found from the Outlook/Tools/Email Accounts
settings.  The smtp and user logins are all there.  Click on the More Tab
and find out which specific SMTP settings are set for the account they want
to use and then use these in CDO.  You can do this for them - takes a few
minutes that's all.

With CDO you do not need Outlook to be open (or any email client).  You can
feed a rst into the functions and send them all during silent hours.  
I have recently sent over 20,000 emails to participants in an event.  No
user overtime required.  It all happened during silent hours.

Very flexible once you start to use it.  No more Outlook warnings etc
(although these can be overcome with ClickYes).
You can wrap it all in a Form to make changes to parameters and feed these
through, etc, etc.

Max

 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at
Beach Access Software
Sent: Saturday, November 24, 2007 1:52 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] SendObject Attachments

Max:

Thanks for the code. It begins to look familiar.  I think I was going to go
this route once but the users would have had trouble configuring it because
they'd need to know their own  smtp server string and stuff like that.   

This will work for the instant application because it's only one site.
However, I'd have to create a form to allow each user to configure to their
won email and password.  (At this point, too, the client is looking for
cheap solutions). But the outlook stuff you sent earlier worked a treat.
Just too a couple minutes to mod for their site and walla! email with pdf
attachments.

Which attachments, BTW, I implemented in a hurry using the Lebans stuff,
thanks again to the list.

Thanks again to the list.

Did I mention how thankful I am to the list?

Best,

Rocky

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

No virus found in this incoming message.
Checked by AVG Free Edition. 
Version: 7.5.503 / Virus Database: 269.16.5/1148 - Release Date: 11/23/2007
7:39 PM
 




More information about the AccessD mailing list