You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@openoffice.apache.org by Caroline Molin <ca...@betonglarsson.se> on 2018/07/02 09:59:22 UTC
Help numbering papers
Hello, I work for a company called Betonglarsson. We use Apache OpenOffice to print transport reports (see attachmet). Now I need help to add the order number where it says NUMBERS, and I need those numbers to change everytime that I print one. I normally print 50 at a time and I have been manually writing the order number on these but I was wondering if there is a way to add an order number to these like a page number? Our order numbers normally starts with the numbers on the licence plate. Here is an example "9990001". We have about 40-50 cars so I need to be able to change the numbers each time I need to print for another car. Thank you in advance!
Regards,
Caroline Molin
BETONGLARSSON AB
M�tarv�gen 16
196 37 Kungs�ngen
Phone: + 46 10 110 43 60
Orgnr: 556366-8093
Website: www.Betonglarsson.se<http://www.betonglarsson.se/>
Mail: Caroline@betonglarsson.se<ma...@betonglarsson.se>
[cid:0ece09c2-32bd-4d30-944a-42fbfc6b1153]
Re: SV: Help numbering papers
Posted by Andrew Pitonyak <an...@pitonyak.org>.
I can think of no way to print multiple directly with a different result every time unless....
1. You use mail merge
2. You generate a multi-page document using a field that increments
3. Use a macro that prints and increments multiple times.
Others probably have better ideas than I.
Sent from BlueMail
On Jul 3, 2018, 3:51 AM, at 3:51 AM, Caroline Molin <ca...@betonglarsson.se> wrote:
>I have a single document and when I print 50 copies I need a new number
>for each one. So it would be 9990001 on the first and 9990050 on the
>last. I have never made a macro so I guess I'll have to look into that.
>Thanks for the help.
>
>-----Ursprungligt meddelande-----
>Från: Andrew Pitonyak <an...@pitonyak.org>
>Skickat: den 2 juli 2018 16:25
>Till: users@openoffice.apache.org
>Ämne: Re: Help numbering papers
>
>
>I just wanted to clarify:
>
>You start with a document that contains the text, which is always a
>number, "9990001".
>
>You open the document and print the document. The document prints the
>text "9990001" as part of the document, but, after print, the text
>reads "9990002". You save the document with the text 9990002.
>
>
>OR
>
>Were you hoping to print the document, request 10 copies, and have it
>print with a different number each time?
>
>OR
>
>You have a single document containing the same text 50 times and each
>copy contains a different number?
>
>
>In my mind, I would write a macro to change the number then print the
>document (if that workflow is possible), but I write many macros!
>
>
>On 2018-07-02 5:59, Caroline Molin wrote:
>> Hello, I work for a company called Betonglarsson. We use Apache
>> OpenOffice to print transport reports (see attachmet). Now I need
>> help
>> to add the order number where it says NUMBERS, and I need those
>> numbers to change everytime that I print one. I normally print 50 at
>> a
>> time and I have been manually writing the order number on these but I
>> was wondering if there is a way to add an order number to these like
>> a
>> page number? Our order numbers normally starts with the numbers on
>> the
>> licence plate. Here is an example "9990001". We have about 40-50 cars
>> so I need to be able to change the numbers each time I need to print
>> for another car. Thank you in advance!
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
>For additional commands, e-mail: users-help@openoffice.apache.org
Re: Help numbering papers
Posted by Jean Lear <me...@gmail.com>.
I do not know if I am over simplifying this or missing the point of the
requirement. I do not know what format the original document is but as a
test I used a writer page and made either a header or a footer on the page.
This can be made whatever size you wish and can be used to insert as much
information as you need and then at the position you want the number to
appear use the > Insert > Fields > Page number and insert your number
999001 on the first page. When you copy the same detail to the next page
the number will change to 999002 going to what ever number you want to go
to (999050)
I had a template set up for my use for Raffle Tickets which have a butt and
tickets four to a page and have the same number on the butt and the tear
off ticket. After setting up page one with numbers one to four, copy that
page, and then paste at the end of page one and the numbers roll on to
whatever number of tickets needed. I had a link to how this was done at -
http://www.oooforum.org/forum/viewtopic.phtml?t=34641 - but I could not
connect to this site as it timed out - may be too old to still exist.
Another idea may be to do a calc sheet with the numbers (999001 to 999050)
and do a mail merge with the original document.
This may give some ideas if I have not missed the point of the original
query.
Jean
melda19@gmail.com
On Tue, Jul 3, 2018 at 5:36 PM, Caroline Molin <ca...@betonglarsson.se>
wrote:
> I have a single document and when I print 50 copies I need a new number
> for each one. So it would be 9990001 on the first and 9990050 on the last.
> I have never made a macro so I guess I'll have to look into that. Thanks
> for the help.
>
> -----Ursprungligt meddelande-----
> Från: Andrew Pitonyak <an...@pitonyak.org>
> Skickat: den 2 juli 2018 16:25
> Till: users@openoffice.apache.org
> Ämne: Re: Help numbering papers
>
>
> I just wanted to clarify:
>
> You start with a document that contains the text, which is always a
> number, "9990001".
>
> You open the document and print the document. The document prints the text
> "9990001" as part of the document, but, after print, the text reads
> "9990002". You save the document with the text 9990002.
>
>
> OR
>
> Were you hoping to print the document, request 10 copies, and have it
> print with a different number each time?
>
> OR
>
> You have a single document containing the same text 50 times and each
> copy contains a different number?
>
>
> In my mind, I would write a macro to change the number then print the
> document (if that workflow is possible), but I write many macros!
>
>
> On 2018-07-02 5:59, Caroline Molin wrote:
> > Hello, I work for a company called Betonglarsson. We use Apache
> > OpenOffice to print transport reports (see attachmet). Now I need
> > help
> > to add the order number where it says NUMBERS, and I need those
> > numbers to change everytime that I print one. I normally print 50 at
> > a
> > time and I have been manually writing the order number on these but I
> > was wondering if there is a way to add an order number to these like
> > a
> > page number? Our order numbers normally starts with the numbers on
> > the
> > licence plate. Here is an example "9990001". We have about 40-50 cars
> > so I need to be able to change the numbers each time I need to print
> > for another car. Thank you in advance!
>
>
SV: Help numbering papers
Posted by Caroline Molin <ca...@betonglarsson.se>.
I have a single document and when I print 50 copies I need a new number for each one. So it would be 9990001 on the first and 9990050 on the last. I have never made a macro so I guess I'll have to look into that. Thanks for the help.
-----Ursprungligt meddelande-----
Från: Andrew Pitonyak <an...@pitonyak.org>
Skickat: den 2 juli 2018 16:25
Till: users@openoffice.apache.org
Ämne: Re: Help numbering papers
I just wanted to clarify:
You start with a document that contains the text, which is always a number, "9990001".
You open the document and print the document. The document prints the text "9990001" as part of the document, but, after print, the text reads "9990002". You save the document with the text 9990002.
OR
Were you hoping to print the document, request 10 copies, and have it print with a different number each time?
OR
You have a single document containing the same text 50 times and each copy contains a different number?
In my mind, I would write a macro to change the number then print the
document (if that workflow is possible), but I write many macros!
On 2018-07-02 5:59, Caroline Molin wrote:
> Hello, I work for a company called Betonglarsson. We use Apache
> OpenOffice to print transport reports (see attachmet). Now I need
> help
> to add the order number where it says NUMBERS, and I need those
> numbers to change everytime that I print one. I normally print 50 at
> a
> time and I have been manually writing the order number on these but I
> was wondering if there is a way to add an order number to these like
> a
> page number? Our order numbers normally starts with the numbers on
> the
> licence plate. Here is an example "9990001". We have about 40-50 cars
> so I need to be able to change the numbers each time I need to print
> for another car. Thank you in advance!
Re: Help numbering papers
Posted by Andrew Pitonyak <an...@pitonyak.org>.
I just wanted to clarify:
You start with a document that contains the text, which is always a
number, "9990001".
You open the document and print the document. The document prints the
text "9990001" as part of the document, but, after print, the text reads
"9990002". You save the document with the text 9990002.
OR
Were you hoping to print the document, request 10 copies, and have it
print with a different number each time?
OR
You have a single document containing the same text 50 times and each
copy contains a different number?
In my mind, I would write a macro to change the number then print the
document (if that workflow is possible), but I write many macros!
On 2018-07-02 5:59, Caroline Molin wrote:
> Hello, I work for a company called Betonglarsson. We use Apache
> OpenOffice to print transport reports (see attachmet). Now I need
> help
> to add the order number where it says NUMBERS, and I need those
> numbers to change everytime that I print one. I normally print 50 at
> a
> time and I have been manually writing the order number on these but I
> was wondering if there is a way to add an order number to these like
> a
> page number? Our order numbers normally starts with the numbers on
> the
> licence plate. Here is an example "9990001". We have about 40-50 cars
> so I need to be able to change the numbers each time I need to print
> for another car. Thank you in advance!