Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2007
    Location
    Big City
    Posts
    62

    Unanswered: merge two tables to send an e-mail from access

    Hello,
    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.

    How to do it in access.

    Thank you so much.

  2. #2
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,424
    Provided Answers: 8
    In queries Click New


    Click desgin view

    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

    Don't forget

    [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)

    Sub Send_Then
    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
    rs.MoveNext
    Loop
    rs.Close
    End Sub
    Last edited by myle; 10-02-07 at 15:43.
    hope this help

    See clear as mud


    StePhan McKillen
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •