Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default How to batch create / generate and print invoices from Excel data?

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 692
Default How to batch create / generate and print invoices from Excel data?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto generate invoices JOJO193 Excel Worksheet Functions 1 November 4th 12 12:41 AM
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 Rizwan[_4_] Excel Discussion (Misc queries) 1 August 6th 09 01:44 PM
automatically generate unique serial numbers for invoices nhlanhla Excel Worksheet Functions 1 October 2nd 08 12:50 PM
Batch print excel files Lamb Chop Excel Discussion (Misc queries) 1 November 7th 07 02:47 PM
Can I batch print several files at once with Excel? blueberry Excel Discussion (Misc queries) 0 July 19th 06 09:44 PM


All times are GMT +1. The time now is 02:11 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"