Send email from Access- please help!!!! 1

[76646]

hi,
I am designing a order, delivery and inventory database.
From the inventory form, I have to send an email to the concerned person about the delivery. The email address is not given seperately but has to be taken from the Employee table and a short text message shoud be sent to that employee telling him about the delivery.
Is it better to use MAPI?
can someone please help me with the code?

thanks

 

[KenReay]

Hi

If you are using Outlook, or OutlookExpress, this is straightforward, see docmd.sendobject in help

Regards Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK
kenneth.reay@talk21.com

 

[mrk2]

how would you do this if you were not using outlook?

 

[KenReay]

Hi

I cannot answer for every EMail client available, but I have succeeded in EMailing from Acecss via Lotus Notes, what di you have in mind?

Regards
Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK
kenneth.reay@talk21.com

 

[mrk2]

A mulberry or eudora system?

 

[KenReay]

Hi

Mulberry I have not come across, Eudora, I suspect docmd.SendObject will still work, why not try it an see, then let us know?

Regards
Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK
kenneth.reay@talk21.com

 

[deduct]

It works in Eudora, as I use it daily (at home).

 

[BVerlaan]

As far as I understand SendObject works for every e-mail client that supports MAPI. I don't no much about MAPI, VIM or SMTP, but Access VBA Help explains a bit more. Search for "SendObject". On an e-mail client that only supports VIM (whatever it may be) you should install an additional dll.

Greetings, Bart Verlaan.