#1
|
|||
|
|||
Print Excel data as reciepts?
I want to use an excel spreadsheet to print reciepts on my clients reciept paper. In order to do this I need to be able to have the fields move where I need them, and for it to print 3 receipts per page. I also need to be able to print them all in one go. Is there something that can help me do this, or do I have to seek out a third party program? |
#2
|
||||
|
||||
Hi halix,
That sounds rather like a simple matter of setting up an output worksheet formatted so that it replicates the data three times on the same page. However, without knowing more about your workbook structure, it's difficult to give firm advice.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
To clarify: I don't want the same receipt 3 times printed on same page, I want 3 different receipts per page.
Data is in this format: FName|Lname|Address1|Address2|City|State|Zip|Phone |Amount|Salesperson|PTime Edit: This is for a call center I am doing some work for. They print up receipts at the end of the day to be sent to the customers. Edit2: Also note this is actually a pipe delimited txt file. all orders are on one list/workbook. |
#4
|
||||
|
||||
Hi halix,
In that case, if it's a bulk production, using Word for a label mailmerge is probably the simplest way to go. Word can use your workbook as the mailmerge data source.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
saving data in excel 2010 from excel 2003 | johnkcalg | Excel | 1 | 02-06-2012 07:33 PM |
excel print issue | excel issue | Excel | 7 | 05-10-2011 12:32 AM |
Is it possible for Excel print consistently with any printer? avoid awkward page brea | William C | Excel | 1 | 12-21-2010 01:40 PM |
Excel Print Preview Problem | jagadiswararao | Excel | 1 | 11-29-2009 06:49 AM |
Excel 2007 doesn't print color graphics on multiple sheets | mwoolf | Excel | 1 | 06-19-2009 02:34 AM |