[AccessD] Sending multiple e-mails

Try blat.  I have a ssd (small sample database) you can try at the 
following url

http://www.rogersaccesslibrary.com/OtherLibraries.asp#Tapia,Francsico

let me know if you need any help.

Stephen Bond wrote:

>Outlook 2000 on the development box, connecting to Windows2000 Server (Exchange Server) on the server box.  All e-mail addresses at present are local, on the customer's computer they won't be.  
>
>I hope this is what you're asking for, I'm no expert in this area :< 
>
>Stephen Bond
>
>  
>
>>-----Original Message-----
>>From: Stuart McLachlan [mailto:stuart at lexacorp.com.pg]
>>Sent: Sunday, 29 February 2004 8:57 p.m.
>>To: Access Developers discussion and problem solving
>>Subject: Re: [AccessD] Sending multiple e-mails
>>
>>
>>On 29 Feb 2004 at 20:21, Stephen Bond wrote:
>>
>>    
>>
>>> The problem is the first record in the recordset pops up as a 
>>> new mail message OK, but subsequent records don't.  The 
>>> debugging MsgBox comes up for each record so I know the loop 
>>> is getting the right records.  Changing the SendObject's 
>>> 'editmessage' flag from True to False doesn't make any difference.
>>> Eventually I want to change the SendObject's 'editmessage' 
>>> flag from True to False so the e-mails   go straight out 
>>> without visual verification.  The False is for testing 
>>> purposes meantime.
>>>
>>>      
>>>
>>What's the mail client? I'd suspect a problem with the client 
>>accepting a second new message when the first one is open.
>>    
>>


-- 
-Francisco