Sending a standard email from Access 2000?

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

Hi,

Thanks very much for that. Thats going to be a great help

Cheers

Simon

Simon

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

http://www.****s-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.

--
**** Kusleika
MVP - Excel
http://www.****s-clicks.com
Post all replies to the newsgroup.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode test 33Switch to Hybrid Mode Switch to Threaded Mode

1 22nd April 01:35 simon harvey External User Posts: 1	Sending a standard email from Access 2000? 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

2 22nd April 01:36 simon harvey External User Posts: 1	Sending a standard email from Access 2000? Hi, Thanks very much for that. Thats going to be a great help Cheers Simon