Hi all.

Is Word a good choice for creating a report and emailing
the report?

What I would like to do is create a report based on an
Access Query that shows a each line item on each invoice
for each customer over a given time period and then
automatically email that report to the customer.

Is this possible to do in Word?  Is it easy?  Should I be
using Access instead?

I don't know if it possible to have grouping in a Word
Mail Merge.  Each record would include customer info,
payment info, the invoice number and date and the Invoice
line item info.  So there would be a record for each
Invoice Line Item.  

I would like the report to group invoices by customer and
group line items by invoice number.  As far as I know this
isn't possible in Word, but a friend told me that perhaps
it is.

Anyone know?

Thanks in advance