how to creatre dinamic statement of account

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to create 246 statement using an easier way. The info to be
changee between statements are customer name, addres and the total amount
due, in just a space . also the Statement date that is the sae for 246
customers.

I have all this data in a spreadcheet
 
The best I can recommend at this point would be to look at Microsoft Word and
search for Mail Merge for help on that subject.

You could create the source document that is your invoice statement using
Word, with it using Name, Address, Total amount from Excel. The date would
be furnished automatically in Word during printing.

This Excel workbook tells how to do this, with pictures to help:
http://www.jlathamsite.com/Teach/WordMailMergeWithExcelDataSource.xls
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Template 9 - Statement of Account 1
Sumifs statemenet returns - , how to use in if statement? 2
If Statement 1
Creating a customer statement of account 1
Failing IF Statement 2
Access MS Access 2010 IIF statement to check if one date is in or out of range of two other dates (fields) 0
statement 1
Make a merge letter, with multiple accounts per person 3

Back
Top