NEW USER - HELP PLEASE

[PC]

Hi all,
I am relatively new to using excel but a fast Learner I hope.

I am secreatry of a semi vol local water supply group for about 450
customers and filling out the bi monthly invoices is rather tedious and
time consuming to say the least .

I want to calculate the following data and create an invoice for each
customer.

Name, Address, Bank Account No, Prevous Units, Present Units , Units Used ,
Cost Per unit, Free units, Total Cost ( ie units less free units * ?3.50) -
Thats the easy bit
But I want this information to be easilt transferred to an invoice which
includes the bank account and perhaps a balance owed ???
Is this complicated
Would I be safer getting another package to do it ?

Any help would be really appreciated
PC

 

[Dave Peterson]

Before you do too much work, you may want to look into using MailMerge (from
MSWord). Keep your data in Excel and create the invoices in MSWord.

These links may help:

http://www.mvps.org/dmcritchie/excel/mailmerg.htm
http://www.mvps.org/word/FAQs/MailMerge

The first is from David McRitchie and the second is by Beth Melton and Dave
Rado.