| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to creatre dinamic statement of account
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to creatre dinamic statement of account
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/Wor...DataSource.xls "yandel" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can a service account be embedded in Workbook so that by default the macros are run with service account credentials and not the user credentials??? | Excel Discussion (Misc queries) | |||
| If Statement? | Excel Discussion (Misc queries) | |||
| Statement of Account | Excel Worksheet Functions | |||
| Help with function to sum values in a worksheet depending on account number | Excel Worksheet Functions | |||
| Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions | |||
Linear Mode
