Need help - Function with emails (1 Viewer)

[emohammed]

Hi all,

I am new and not sure if this is the right area... but please advise..

I will try to describe concisely what I want to do and please advise if I am on the right path.

The objective is to have a query that return several records that display on the screen with columns changeID, changeDesc, ChangeDate. etc.

This query (say qry_1) retrieves record from 2 tables T1 and T2.

I now want to take each of the displayed changeID from the retrieved output (say 3 records) and generate separate emails but getting more information from T3 (key is changeID) and put this information in the BODY of the Outlook email and NOT as an attachment.

So where do I start. What I have is
qry_1 --- to select all the rows that I need to send the email
qry_2 -- for each of the changeID, I have the information in a form.

How do I loop through the selected records and based on the changeID run the qry 2 and put this in a separate email.

 

[Mihail]

While we don't know the structure of your DB is hard to provide advices.
My guess, based on your description, is to design a query that select ALL the information from ALL 3 tables.

About how to loop through a recordset, read this:
http://stackoverflow.com/questions/5864160/code-to-loop-through-all-records-in-ms-access
or do yourself a search with google.

Can't answer how to email this, but I'm sure that you can find a lot of code on the web.