emailing a report grouped

  • Thread starter Thread starter mcwitz
  • Start date Start date
M

mcwitz

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???
 
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
 
Back
Top