Sending a standard email from Access 2000?

[Simon Harvey]

Hi everyone,

Does anyone happen to have any code or advice on how I could create a
standard email object - using Access 2000 and then send it to a specified
address from an access table?

Any advice at all would be greatfully received

Thanks everyone

Kind Regards

Simon

 

[Dick Kusleika]

Simon

Here's a page on my site that explains how to do it in Excel.

http://www.dicks-clicks.com/excel/olSending.htm

There's very little that's Excel specific. You'll need to create a
Recordset object and loop through it to find the address which you can then
assign tot the To property of the MailItem object.