Re: how do u send an email using access?

In message <dt8dli$ffl$1@xxxxxxxxxxxxxxxxxx>, Tim Marshall <TIMMY!@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx> writes
fredg wrote:

DoCmd.SendObject acSendNoObject, , acFormatTXT, [EmailAddressField], ,
, "Item not returned", "Please return the film you have rented." &
vbNewLine & "There is a late fee of $2.00 per day.", True

One irritating thing the help file does not tell you is that sendobject DOES NOT WORK PROPERLY with netscape as the default mail client. It is unable to fill in the to header and unless you have the email generated so that you can physically add it in, it won't send a blinking thing.

This problem is with Access 2003 Sp2 and Netscape 7.2.

I've seen the same problem using Access 2000 and Turnpike as the mail client. I suspect that it may only work with Outlook.



--
Bernard Peek
London, UK. DBA, Manager, Trainer & Author.

.

Relevant Pages
Loading