#1
|
|||
|
|||
Adding names to sheet for printing
I am the secretary for my volunteer fire department. To maintain active status, all members have to log 14 hours a month. We have a sheet that a prior secretary made that the members write their hours on, and turn in. Currently each month I have to print 42 copies of the sheet, and write everyone's names, badge numbers, and the month on them.
What I am looking to do is be able to list all the member's names and badge numbers, and the month, and have it output a sheet with the names, badge number, and month already filled in, that way I don't have to write 42 members names down. I don't have a copy of our actual file with me, but I made one that looks very similar up, and have attached it. Again, I just want to make it so the Name: Unit #: and Month: fields are already filled in with information from a list for printing. Is this possible? Thanks |
#2
|
|||
|
|||
Something like the attached?
|
#3
|
||||
|
||||
You could also try using Word's Mail merge functionality if you have it
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#4
|
|||
|
|||
Awesome. That is exactly what I needed.
Thanks a ton! |
#5
|
|||
|
|||
I took the liberty of playing around with your workbook a little more.
Have a look at this and see if it helps you at all. Regards |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Printing two A5 documents on A4 sheet | Glyn406 | Word | 2 | 12-21-2012 12:28 AM |
Printing sheet | msheyworth | Excel | 0 | 08-23-2012 07:19 AM |
How to enter names in Resource Pool/names | pstein | Project | 1 | 03-26-2012 07:37 AM |
auto insert names from list for printing | andreipopa2k | Word | 1 | 12-09-2011 01:51 PM |
Printing document with style names | Steve_D | Word | 0 | 12-10-2009 09:23 PM |