Email from access

[S.Dickson]

Hi

I hope some one can help, as i am not very good on Access


I have built a database for placing orders for customers, On the Order
Form i would like a button that would send out a email to say that the
order has been placed, then another button that order has been
despatched.


I have looked on the internet for code and found sum but do not
understand it.
As the order form only has Customer Number im not sure how to code it
to look up customers email address from tblCustomers


If any one could help i would be very greatful i am able to send the
database to you if u want to have a look but i can warn you it not
great.


Thanks


Simon

 

[DS]

Hi

I hope some one can help, as i am not very good on Access


I have built a database for placing orders for customers, On the Order
Form i would like a button that would send out a email to say that the
order has been placed, then another button that order has been
despatched.


I have looked on the internet for code and found sum but do not
understand it.
As the order form only has Customer Number im not sure how to code it
to look up customers email address from tblCustomers


If any one could help i would be very greatful i am able to send the
database to you if u want to have a look but i can warn you it not
great.


Thanks


Simon

Simon, Check my post "WildCard" I think its the next to the last one,
it's the THIS WORKS one....the code works pretty good, also you can
check www.Marshallsoft.com and download SMPT/POP3 SEE it's free for
sixty days, after that it stops working unless you pay $105.00, it's
really good and Mike Marshall is very helpful!
DS