Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm not sure if this is even possible, but if it is...
Is there a way to automatically create multiple packing slips or invoices from excel data? In my case, we can download a csv file with hundreds of customers' names, addresses, and orders. I want a way to automatically create a packing slip for each order (they can be on the same sheet, with page breaks) and print the slip, instead of having to create a new packing slip manually for each order. All the data is there.. I just need a way to create something out of it. We do this every morning, so something easy to use would be great. |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
You could create a Mail Merge in Microsoft Word and use the Excel workbook
as the data source. You can also create a custom label size to match your packing slip size. And once you get it set up, you should be able to save it and reuse it with new data anytime you desire... -- steveB Remove "AYN" from email to respond "helenerz" wrote in message ... I'm not sure if this is even possible, but if it is... Is there a way to automatically create multiple packing slips or invoices from excel data? In my case, we can download a csv file with hundreds of customers' names, addresses, and orders. I want a way to automatically create a packing slip for each order (they can be on the same sheet, with page breaks) and print the slip, instead of having to create a new packing slip manually for each order. All the data is there.. I just need a way to create something out of it. We do this every morning, so something easy to use would be great. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Auto generate invoices | Excel Worksheet Functions | |||
How to create a macro in excel so that it can generate a list ofunique records using all permutations and combinations of the data in eachrow ad column | Excel Discussion (Misc queries) | |||
automatically generate unique serial numbers for invoices | Excel Worksheet Functions | |||
Batch print excel files | Excel Discussion (Misc queries) | |||
Can I batch print several files at once with Excel? | Excel Discussion (Misc queries) |