I've got a list from a heating company who services customer's and
keeps their list by item (ie: air conditioner, heater, etc) so the
customer id's are the same for each customer, but there are multiple
rows for each customer. In order to do a mail merge and have all of
the customer data be the same (to do billing), everything needs to be
on the same line. The consistant data is their name, address,
customer id. Variable data is the amount owed, item serviced, make
and model number. How do I go about doing this?

Do you need to send a bill for each item on the list, or have some of
the items already been billed?

On Feb 20, 6:35*pm, dan dungan wrote:
Do you need to send a bill for each item on the list, or have some of
the items already been billed?

Ideally, we'd be sending a bill for every item on the list but I want
to put multiple bills on one invoice.

Try looking at the information at Peter's web site:

http://www.excel-examples.com/article-database.htm

Especially the sumproduct and index links.

I'm leaving the office now. I'll check in tomorrow.

On Feb 20, 7:52 pm, dan dungan wrote:
Try looking at the information at Peter's web site:

http://www.excel-examples.com/article-database.htm

Especially the sumproduct and index links.

I'm leaving the office now. I'll check in tomorrow.

It's good info - but we're still having trouble getting it to work. I
think we need some sort of formula (if customer number is the same,
then put it all together on the same line) or macro. Thoughts?

Hi,

I've been out of the office since last thursday.

Would you mind including some sample data so I could see the format
your using?

Dan