Unanswered: merge two tables to send an e-mail from access
how to merge two tables in order to send an e-mail from access based on the data from these tables.
One Table has an email , Acct Names, orderid and the other table has style# and orderid.
(note there are might be multy orderid's in the other table due to multiple style# per order.)
I also have a text for e-mail (same for every email), so i need to be able to send that e-mail using AcctName, Email address, orderid and all styles attached.
Select the Tables you want to add
If the tables don't join then selfs
just click on a field and drop it in the other feild you want it to join to
( the feilds must be the same type not text <X> number )
Then double click the Feilds you want to see
run it does it look right
[table] => [query] => [query] => [query] => [What you want to see]
this can slow you down
Then Once you are seeing the data you want
Know the Codeing side come in ( the fun stuff)
Dim db As Database
Dim rs As Recordset
Set db = CurrentDb
Set rs = db.OpenRecordset("Finish it")
Do Until rs.EOF
DoCmd.SendObject , , , rs.feild("emial"), "", "","Weekly updates", rs.feild("DatatoSend"), False
Last edited by myle; 10-02-07 at 14:43.
hope this help
See clear as mud
the aim is store once, not store multiple times
Remember... Optimize 'til you die!
Progaming environment: Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010 VB based on my own environment: vb6 sp5 ASP based on my own environment: 5.6 VB-NET based on my own environment started 2007 SQL-2005 based on my own environment started 2008 MYLE YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.