Need help - Function with emails (1 Viewer)

emohammed

New member
Local time
Yesterday, 19:09
Joined
May 29, 2015
Messages
3
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

Registered User.
Local time
Today, 05:09
Joined
Jan 22, 2011
Messages
2,373
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.
 

Users who are viewing this thread

Top Bottom