Print a Statement from a list

[Guest]

I have a list of outstanding invoices for several customers. I regularly need
to issue statement based on list of open invoices. I wish to create a
template where i would select individual records to chase payments.

I wish the template would accomodate one or more lines depending on number
of open invoices for one customer.

my list contains one line for each and every transaction i.e invoice number
transaction date, customer order number,details, outstanding amt.

I was also considering emailing the statement directly from Excel, but this
is not my current priority.
Anyone can help?

 

[Guest]

Answer: Print using Custom View.

Do the following:

1. Select a range of cells.
2. On the View menu, click Custom Views.
3. In the Views box, click the name of the view
(view: A set of display and print settings that you can name and apply
to a
workbook. You can create more than one view of the same workbook without
saving separate copies of the workbook.) you want to print.
4. Click Show.
The range of cells will be shown as selected
5. Click Print.
6. Under Print What, click Selection
7. Click OK.

Note: You craete as many Custom View as possible, and print only those
views. Most important thing is you must select the range and during print you
must select Selection option. You can chage the Page sige before printing.

Challa Prabhu