emailing a report grouped

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mcwitz@gmail.com - 25 Jul 2006 06:12 GMT

Sorry, I know this is confusing, but I have to believe I am not asking
for something crazy here. I have a database with 100 rows in it. Of
the 100 rows, most have the same customer, but the rows are different
because they have different products they are selling.
So, what i want to do, is create a single email to a given customer
with all their products on the page (meaning multiple rows in the table
in a single email).
Generally, you do this by grouping, but I can figure out how, once i
have this stuff grouped, to email it off to an email address in the
row. Any ideas???

Reply to this Message

Wayne-I-M - 25 Jul 2006 08:26 GMT

Hi

I know this isn't what you want to hear but I would suggest that 1st you
create a new table [tblProducts] and link this to your customer's table with
a 1 to many relationship. This will make the e mails that you want to send
much easier. (link the [tblproducts] with [tblCustomers] by inserting the
[productID] in the [tblCustomers].

Press F1 for more help on relationships and how to create them.

If you don't want to do this run your email from a totals query to select
only one record for each customer and then run the e mails either from vba
(use DoCmd.SendObject) or create a send object macro.

Hope this helps

Signature

Wayne
Manchester, England.

> Sorry, I know this is confusing, but I have to believe I am not asking
> for something crazy here. I have a database with 100 rows in it. Of
[quoted text clipped - 6 lines]
> have this stuff grouped, to email it off to an email address in the
> row. Any ideas???

Reply to this Message