How do i collect data from 2 tables in 1 email?

[nickblitz]

as above.



please advise!

[redbull]

Details would be useful.. and I have posted the Email code a few times now... Did that not work? are you looking to modify something in the code? What are the table names?

[redbull]

  Sub CreateHTMLMail()
        ''''Creates a new e-mail item and modifies its properties'


    Dim olApp As Outlook.Application
    Dim objMail As Outlook.MailItem
    Set olApp = Outlook.Application
    'Create e-mail item'
    Set objMail = olApp.CreateItem(olMailItem)
 


          ''' Assigning things above in outlook mail message.
      With objMail
        .Subject = 
        .Body = 
        .To = 
        .Display
        .ReadReceiptRequested = True
      End With
  End Sub

Might have to dim a couple things out and then set them as the specific thing you want... not sure how thats done but I'm sure its possible.

[nickblitz]

under external data tab theres this thing called create email.


i want to collect data to update existing data from 2 tables. i realize that i can't because access only allows me to get from 1 table.

what does the above code do?