Help? Microsoft Office - merging data.
I'm not a big Microsoft anything. I fix programs, I tend to not over use office products. I install them, I upgrade them, I patch them, I get rid of what's infecting them, but I rarely use them.
So today I sit down to do something of a sort I haven't done since the DOS days, and never did it quite this way anyways. We have a form at NASA we simply refer to as a yellow tag. It holds some info like description, serial number, that sort of thing and it gets stuck to the item, whatever it may be, while it sits on the shelf awaiting use.
We did inventory on some cabinets the other day and we need to make new yellow tags, we saved the data into an Excel spread sheet.
Using a yellow tag someone made in Power Point I pasted that into a word document and was able to make it automatically put the right info in the right blanks. I have a problem however, I can only put one per page.
When I put in the "next form" tag through the menu system it does not go to the next form, I don't know how it would render in this format so I'm using the wrong characters to enclose the tag for reference ((Next Form)) or something like that is the tag. It doesn't work. If I put three of those forms on a page with the ((Next Form)) tag (or similar, I'm not 100% sure that was right) it will print three of the same tag on the same page then go to the next page and print three of the next tag. That is a huge waste of paper. I've tried tricks like "Two pages per page". If I try that on the application it cuts the page in half and changes the orientation, that cuts the tag off and it wont fit. So I change the orientation back, but leave it split, fine, it decides it only wants to put one tag per page if I change the orientation back. I change the printer driver to do two pages per page. I condenses the output into much to small of a tag. I cannot rotate the form I'm using. It flat wont rotate or sideways would be fine. I've even tried telling Word it was an address label, fine, it likes address labels, as long as there's three of the same kind on a sheet. Printing just one then turning the paper around to print on the other half just causes printer jams.
Anybody know how to force it to read the next row of the spread sheet before filling in the next form? I'm not typically an office use, just a supporter, it's easy for these things to slip past me.
As it stands I think my best option at this point with my level of knowledge is to do the software page split, turn the yellow tag into an image, turn it sideways and make all my text fields that draw in data from the spread sheet sideways. If I start from scratch sideways I think I can make it work, but I know I shouldn't have to do it that way. There has to be something to make it read the next damn row.
So today I sit down to do something of a sort I haven't done since the DOS days, and never did it quite this way anyways. We have a form at NASA we simply refer to as a yellow tag. It holds some info like description, serial number, that sort of thing and it gets stuck to the item, whatever it may be, while it sits on the shelf awaiting use.
We did inventory on some cabinets the other day and we need to make new yellow tags, we saved the data into an Excel spread sheet.
Using a yellow tag someone made in Power Point I pasted that into a word document and was able to make it automatically put the right info in the right blanks. I have a problem however, I can only put one per page.
When I put in the "next form" tag through the menu system it does not go to the next form, I don't know how it would render in this format so I'm using the wrong characters to enclose the tag for reference ((Next Form)) or something like that is the tag. It doesn't work. If I put three of those forms on a page with the ((Next Form)) tag (or similar, I'm not 100% sure that was right) it will print three of the same tag on the same page then go to the next page and print three of the next tag. That is a huge waste of paper. I've tried tricks like "Two pages per page". If I try that on the application it cuts the page in half and changes the orientation, that cuts the tag off and it wont fit. So I change the orientation back, but leave it split, fine, it decides it only wants to put one tag per page if I change the orientation back. I change the printer driver to do two pages per page. I condenses the output into much to small of a tag. I cannot rotate the form I'm using. It flat wont rotate or sideways would be fine. I've even tried telling Word it was an address label, fine, it likes address labels, as long as there's three of the same kind on a sheet. Printing just one then turning the paper around to print on the other half just causes printer jams.
Anybody know how to force it to read the next row of the spread sheet before filling in the next form? I'm not typically an office use, just a supporter, it's easy for these things to slip past me.
As it stands I think my best option at this point with my level of knowledge is to do the software page split, turn the yellow tag into an image, turn it sideways and make all my text fields that draw in data from the spread sheet sideways. If I start from scratch sideways I think I can make it work, but I know I shouldn't have to do it that way. There has to be something to make it read the next damn row.