[AccessD] emailing a newsletter

Another option is to send from VBA using the Outlook object model.
Depending on the version and how you approach it, you may run across a
Microsoft security "feature" that prevents code from accessing the address
book.  The cure is Outlook Redemption (http://www.dimastr.com/redemption/).


I might have some code lying around.  If I find it, I will put it up on my
website and send another message.

Regards,

Steve Goodhall
www.goodhall.info/steve


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan
Sent: Friday, September 10, 2004 6:44 PM
To: Access Developers discussion and problemsolving
Subject: Re: [AccessD] emailing a newsletter

On 10 Sep 2004 at 10:30, augusta wrote:

> I have a client who has about 700 email addresses within an Access
database
> to whom she would like to send a newsletter.
> 
> Can anyone suggest a good way of going about this, other than
> query/copy/paste in to outlook? 

I generally use Blat (either the exe or dll version) for this sort of 
thing.  http://www.geocities.com/toby_korn/blat/

> Also, for some reason when she does it this
> way, she can only use about 50 address.
> 

Many ISPs set up there SMTP servers to only accept 50 or so to addresses in 
a single message as an anti-spam measure.

Using Blat, you can easily send out one message to each address rather than 
bundling them so the limit doesn;t matter.




-- 
Stuart


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