Send Email from Access

  • Thread starter Thread starter S.Dickson
  • Start date Start date
S

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
 
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
Click to expand...

Hi Simon

1. Pay a real programmer to do the work for you.

2. Failing that, you'll have to struggle on. Sounds like you need to learn
basic SQL, apart from anything else. A typical Sql Statement might be
something like "select emailaddress from tblCustomers where customerid=53"

3. Post in an Access newsgroup, as I think your biggest issues are not with
Outlook.

4. Good luck, you'll need it.


--
John Blessing

http://www.LbeHelpdesk.com - Help Desk software priced to suit all
businesses
http://www.room-booking-software.com - Schedule rooms & equipment bookings
for your meeting/class over the web.
http://www.lbetoolbox.com - Remove Duplicates from MS Outlook, find/replace,
send newsletters
 
Back
Top