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
--
Wayne
Manchester, England.
"mcwitz[ at ]gmail.com" wrote:
[Quoted Text] > 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???
>
>
|