help with programming

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 2 tables one with names of companies and one with points of contacts
including email addresses.

I need send email to all the addresses for all the companies that I query in
my daily query. How can I get the right output so I only send one email per
company with as many addresses as needed. I am using the send object method
to send emails.

Any code you could provide with the logic I need would be helpful.

Matthew
 
wrightlife11 said:
I have 2 tables one with names of companies and one with points of
contacts including email addresses.

I need send email to all the addresses for all the companies that I
query in my daily query. How can I get the right output so I only
send one email per company with as many addresses as needed. I am
using the send object method to send emails.

Any code you could provide with the logic I need would be helpful.

Matthew
Click to expand...

You could use the fConcatChild function posted here:

http://www.mvps.org/access/modules/mdl0004.htm

in a query, to return a concatenated list of all the email addresses for
the current company.
 
Back
Top