Help!

WORD template - sequential numbering

 
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Document Management RSS
Next:  Can Word 2000 open a Word 2003 doc file successfu..  
Author Message
dgk
External


Since: Sep 13, 2006
Posts: 7



PostPosted: Thu Sep 14, 2006 7:33 pm    Post subject: WORD template - sequential numbering
Archived from groups: microsoft>public>word>docmanagement (more info?)

I am trying to figure out how to use this template:
http://office.microsoft.com/en-ca/templates/TC012265191033.aspx. How do I
make 100 tickets and have the numbers automatically update?
Back to top
Pop`
External


Since: Aug 07, 2006
Posts: 38



PostPosted: Fri Sep 15, 2006 5:09 pm    Post subject: Re: WORD template - sequential numbering [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

dgk wrote:
> I am trying to figure out how to use this template:
> http://office.microsoft.com/en-ca/templates/TC012265191033.aspx. How
> do I make 100 tickets and have the numbers automatically update?

Huh! Good question! I expected to see a macro in the template, or at least
some way to keep the numbering going for successive pages. It looks to me
like someone "forgot" something. There's a Black & White version of another
one too, with the same problem.

I've lost the source for where I got this, but here's a short blurb on
creating sequential numbers if it helps any.
-------------------
Make an AutoText entry as follows: In the body of any document, type the
brackets and the letter Q as regular text. Between the Q and the closing
bracket, insert a Sequence field, which supplies the number. Now select the
whole thing and press Alt+F3 and assign a name to the AutoText entry that
you wouldn't ordinarily use as a word, such as "qtag".

Each time you type that name in text, you'll see a yellow tooltip that says
"Press Enter to insert". Actually, you can press Enter, Tab, or F3, as any
of them will insert the AutoText entry.

If you insert new entries between existing ones, those that follow it don't
update automatically. You'll have to press Ctrl+A to select the whole
document and then press F9 to update the fields. (Alternatively, switch to
Print Preview and back.)

------------------------------------------



HTH,


Pop`
Back to top
dgk
External


Since: Sep 13, 2006
Posts: 7



PostPosted: Fri Sep 15, 2006 5:09 pm    Post subject: Re: WORD template - sequential numbering [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Thank you I will give that a try Smile

"Pop`" wrote:

> dgk wrote:
> > I am trying to figure out how to use this template:
> > http://office.microsoft.com/en-ca/templates/TC012265191033.aspx. How
> > do I make 100 tickets and have the numbers automatically update?
>
> Huh! Good question! I expected to see a macro in the template, or at least
> some way to keep the numbering going for successive pages. It looks to me
> like someone "forgot" something. There's a Black & White version of another
> one too, with the same problem.
>
> I've lost the source for where I got this, but here's a short blurb on
> creating sequential numbers if it helps any.
> -------------------
> Make an AutoText entry as follows: In the body of any document, type the
> brackets and the letter Q as regular text. Between the Q and the closing
> bracket, insert a Sequence field, which supplies the number. Now select the
> whole thing and press Alt+F3 and assign a name to the AutoText entry that
> you wouldn't ordinarily use as a word, such as "qtag".
>
> Each time you type that name in text, you'll see a yellow tooltip that says
> "Press Enter to insert". Actually, you can press Enter, Tab, or F3, as any
> of them will insert the AutoText entry.
>
> If you insert new entries between existing ones, those that follow it don't
> update automatically. You'll have to press Ctrl+A to select the whole
> document and then press F9 to update the fields. (Alternatively, switch to
> Print Preview and back.)
>
> ------------------------------------------
>
>
>
> HTH,
>
>
> Pop`
>
>
>
Back to top
dgk
External


Since: Sep 13, 2006
Posts: 7



PostPosted: Fri Sep 15, 2006 5:09 pm    Post subject: Re: WORD template - sequential numbering [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

I tried the Autotext and it worked except it prints the (Q#). How do I
aleviate the brackets and Q. Also do I have to do this 100 times for 100
tickets?

"dgk" wrote:

> Thank you I will give that a try Smile
>
> "Pop`" wrote:
>
> > dgk wrote:
> > > I am trying to figure out how to use this template:
> > > http://office.microsoft.com/en-ca/templates/TC012265191033.aspx. How
> > > do I make 100 tickets and have the numbers automatically update?
> >
> > Huh! Good question! I expected to see a macro in the template, or at least
> > some way to keep the numbering going for successive pages. It looks to me
> > like someone "forgot" something. There's a Black & White version of another
> > one too, with the same problem.
> >
> > I've lost the source for where I got this, but here's a short blurb on
> > creating sequential numbers if it helps any.
> > -------------------
> > Make an AutoText entry as follows: In the body of any document, type the
> > brackets and the letter Q as regular text. Between the Q and the closing
> > bracket, insert a Sequence field, which supplies the number. Now select the
> > whole thing and press Alt+F3 and assign a name to the AutoText entry that
> > you wouldn't ordinarily use as a word, such as "qtag".
> >
> > Each time you type that name in text, you'll see a yellow tooltip that says
> > "Press Enter to insert". Actually, you can press Enter, Tab, or F3, as any
> > of them will insert the AutoText entry.
> >
> > If you insert new entries between existing ones, those that follow it don't
> > update automatically. You'll have to press Ctrl+A to select the whole
> > document and then press F9 to update the fields. (Alternatively, switch to
> > Print Preview and back.)
> >
> > ------------------------------------------
> >
> >
> >
> > HTH,
> >
> >
> > Pop`
> >
> >
> >
Back to top
Suzanne S. Barnhill
External


Since: Sep 26, 2003
Posts: 24483



PostPosted: Fri Sep 15, 2006 8:41 pm    Post subject: Re: WORD template - sequential numbering [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

You might want to see http://www.gmayor.com/Numbered_labels.htm

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"dgk" wrote in message

> I tried the Autotext and it worked except it prints the (Q#). How do I
> aleviate the brackets and Q. Also do I have to do this 100 times for 100
> tickets?
>
> "dgk" wrote:
>
> > Thank you I will give that a try Smile
> >
> > "Pop`" wrote:
> >
> > > dgk wrote:
> > > > I am trying to figure out how to use this template:
> > > > http://office.microsoft.com/en-ca/templates/TC012265191033.aspx. How
> > > > do I make 100 tickets and have the numbers automatically update?
> > >
> > > Huh! Good question! I expected to see a macro in the template, or at
least
> > > some way to keep the numbering going for successive pages. It looks
to me
> > > like someone "forgot" something. There's a Black & White version of
another
> > > one too, with the same problem.
> > >
> > > I've lost the source for where I got this, but here's a short blurb on
> > > creating sequential numbers if it helps any.
> > > -------------------
> > > Make an AutoText entry as follows: In the body of any document, type
the
> > > brackets and the letter Q as regular text. Between the Q and the
closing
> > > bracket, insert a Sequence field, which supplies the number. Now
select the
> > > whole thing and press Alt+F3 and assign a name to the AutoText entry
that
> > > you wouldn't ordinarily use as a word, such as "qtag".
> > >
> > > Each time you type that name in text, you'll see a yellow tooltip that
says
> > > "Press Enter to insert". Actually, you can press Enter, Tab, or F3, as
any
> > > of them will insert the AutoText entry.
> > >
> > > If you insert new entries between existing ones, those that follow it
don't
> > > update automatically. You'll have to press Ctrl+A to select the whole
> > > document and then press F9 to update the fields. (Alternatively,
switch to
> > > Print Preview and back.)
> > >
> > > ------------------------------------------
> > >
> > >
> > >
> > > HTH,
> > >
> > >
> > > Pop`
> > >
> > >
> > >
Back to top
Doug Robbins - Word MVP
External


Since: Jul 14, 2006
Posts: 2843



PostPosted: Sat Sep 16, 2006 1:42 am    Post subject: Re: WORD template - sequential numbering [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

See the article "Sequentially numbering multiple copies of single document
using a macro" at:

http://www.word.mvps.org/FAQs/MacrosVBA/NumberCopiesOf1Doc.htm

or

See the article "Sequentially numbering multiple copies of single document
using a mailmerge" at:

http://www.word.mvps.org/FAQs/MailMerge/NumberCopiesOfDocMMerge.htm

or

See the article "Creating sequentially numbered documents (such as
invoices)" at:

http://www.word.mvps.org/FAQs/MacrosVBA/NumberDocs.htm




--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"dgk" wrote in message

>I tried the Autotext and it worked except it prints the (Q#). How do I
> aleviate the brackets and Q. Also do I have to do this 100 times for 100
> tickets?
>
> "dgk" wrote:
>
>> Thank you I will give that a try Smile
>>
>> "Pop`" wrote:
>>
>> > dgk wrote:
>> > > I am trying to figure out how to use this template:
>> > > http://office.microsoft.com/en-ca/templates/TC012265191033.aspx. How
>> > > do I make 100 tickets and have the numbers automatically update?
>> >
>> > Huh! Good question! I expected to see a macro in the template, or at
>> > least
>> > some way to keep the numbering going for successive pages. It looks to
>> > me
>> > like someone "forgot" something. There's a Black & White version of
>> > another
>> > one too, with the same problem.
>> >
>> > I've lost the source for where I got this, but here's a short blurb on
>> > creating sequential numbers if it helps any.
>> > -------------------
>> > Make an AutoText entry as follows: In the body of any document, type
>> > the
>> > brackets and the letter Q as regular text. Between the Q and the
>> > closing
>> > bracket, insert a Sequence field, which supplies the number. Now select
>> > the
>> > whole thing and press Alt+F3 and assign a name to the AutoText entry
>> > that
>> > you wouldn't ordinarily use as a word, such as "qtag".
>> >
>> > Each time you type that name in text, you'll see a yellow tooltip that
>> > says
>> > "Press Enter to insert". Actually, you can press Enter, Tab, or F3, as
>> > any
>> > of them will insert the AutoText entry.
>> >
>> > If you insert new entries between existing ones, those that follow it
>> > don't
>> > update automatically. You'll have to press Ctrl+A to select the whole
>> > document and then press F9 to update the fields. (Alternatively, switch
>> > to
>> > Print Preview and back.)
>> >
>> > ------------------------------------------
>> >
>> >
>> >
>> > HTH,
>> >
>> >
>> > Pop`
>> >
>> >
>> >
Back to top
dgk
External


Since: Sep 13, 2006
Posts: 7



PostPosted: Sat Sep 16, 2006 1:42 am    Post subject: Re: WORD template - sequential numbering [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Wow - I will give those all a try - this is testing my WORD skills in areas I
have never gone before. Thanks for the info and the links to your website. I
will find the information helpful. dgk

"Doug Robbins - Word MVP" wrote:

> See the article "Sequentially numbering multiple copies of single document
> using a macro" at:
>
> http://www.word.mvps.org/FAQs/MacrosVBA/NumberCopiesOf1Doc.htm
>
> or
>
> See the article "Sequentially numbering multiple copies of single document
> using a mailmerge" at:
>
> http://www.word.mvps.org/FAQs/MailMerge/NumberCopiesOfDocMMerge.htm
>
> or
>
> See the article "Creating sequentially numbered documents (such as
> invoices)" at:
>
> http://www.word.mvps.org/FAQs/MacrosVBA/NumberDocs.htm
>
>
>
>
> --
> Hope this helps.
>
> Please reply to the newsgroup unless you wish to avail yourself of my
> services on a paid consulting basis.
>
> Doug Robbins - Word MVP
>
> "dgk" wrote in message
>
> >I tried the Autotext and it worked except it prints the (Q#). How do I
> > aleviate the brackets and Q. Also do I have to do this 100 times for 100
> > tickets?
> >
> > "dgk" wrote:
> >
> >> Thank you I will give that a try Smile
> >>
> >> "Pop`" wrote:
> >>
> >> > dgk wrote:
> >> > > I am trying to figure out how to use this template:
> >> > > http://office.microsoft.com/en-ca/templates/TC012265191033.aspx. How
> >> > > do I make 100 tickets and have the numbers automatically update?
> >> >
> >> > Huh! Good question! I expected to see a macro in the template, or at
> >> > least
> >> > some way to keep the numbering going for successive pages. It looks to
> >> > me
> >> > like someone "forgot" something. There's a Black & White version of
> >> > another
> >> > one too, with the same problem.
> >> >
> >> > I've lost the source for where I got this, but here's a short blurb on
> >> > creating sequential numbers if it helps any.
> >> > -------------------
> >> > Make an AutoText entry as follows: In the body of any document, type
> >> > the
> >> > brackets and the letter Q as regular text. Between the Q and the
> >> > closing
> >> > bracket, insert a Sequence field, which supplies the number. Now select
> >> > the
> >> > whole thing and press Alt+F3 and assign a name to the AutoText entry
> >> > that
> >> > you wouldn't ordinarily use as a word, such as "qtag".
> >> >
> >> > Each time you type that name in text, you'll see a yellow tooltip that
> >> > says
> >> > "Press Enter to insert". Actually, you can press Enter, Tab, or F3, as
> >> > any
> >> > of them will insert the AutoText entry.
> >> >
> >> > If you insert new entries between existing ones, those that follow it
> >> > don't
> >> > update automatically. You'll have to press Ctrl+A to select the whole
> >> > document and then press F9 to update the fields. (Alternatively, switch
> >> > to
> >> > Print Preview and back.)
> >> >
> >> > ------------------------------------------
> >> >
> >> >
> >> >
> >> > HTH,
> >> >
> >> >
> >> > Pop`
> >> >
> >> >
> >> >
>
>
>
Back to top
iaglarch
External


Since: May 14, 2009
Posts: 1



PostPosted: Thu May 14, 2009 6:50 pm    Post subject: Re: WORD template - sequential numbering [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

I followed the instruction to create sequentially numbered documents (such as
invoices) and the first document opened with the macro enters the specific
number Order = 4209 instead of adding 1 + 4209. Can you tell me from the
attached macro what I am doing incorrectly?

Thanks,

Sub AutoNew()
'
' AutoNew Macro
' Macro created 5/14/2009 by VC of Finance
'
Order = System.PrivateProfileString("C:\Settings.Txt", "MacroSettings",
"Order")
If Order = "" Then
Order = 4209
Else
Order = Order + 1
End If

System.PrivateProfileString("C:Settings.txt", "MacroSettings", "Order") =
Order

ActiveDocument.Bookmarks("Order").Range.InsertBefore Format(Order, "00#")
ActiveDocument.SaveAs FileName:="path" & Format(Order, "00#")


End Sub





"Suzanne S. Barnhill" wrote:

> You might want to see http://www.gmayor.com/Numbered_labels.htm
>
> --
> Suzanne S. Barnhill
> Microsoft MVP (Word)
> Words into Type
> Fairhope, Alabama USA
> Word MVP FAQ site: http://word.mvps.org
> Email cannot be acknowledged; please post all follow-ups to the newsgroup so
> all may benefit.
>
> "dgk" wrote in message
>
> > I tried the Autotext and it worked except it prints the (Q#). How do I
> > aleviate the brackets and Q. Also do I have to do this 100 times for 100
> > tickets?
> >
> > "dgk" wrote:
> >
> > > Thank you I will give that a try Smile
> > >
> > > "Pop`" wrote:
> > >
> > > > dgk wrote:
> > > > > I am trying to figure out how to use this template:
> > > > > http://office.microsoft.com/en-ca/templates/TC012265191033.aspx. How
> > > > > do I make 100 tickets and have the numbers automatically update?
> > > >
> > > > Huh! Good question! I expected to see a macro in the template, or at
> least
> > > > some way to keep the numbering going for successive pages. It looks
> to me
> > > > like someone "forgot" something. There's a Black & White version of
> another
> > > > one too, with the same problem.
> > > >
> > > > I've lost the source for where I got this, but here's a short blurb on
> > > > creating sequential numbers if it helps any.
> > > > -------------------
> > > > Make an AutoText entry as follows: In the body of any document, type
> the
> > > > brackets and the letter Q as regular text. Between the Q and the
> closing
> > > > bracket, insert a Sequence field, which supplies the number. Now
> select the
> > > > whole thing and press Alt+F3 and assign a name to the AutoText entry
> that
> > > > you wouldn't ordinarily use as a word, such as "qtag".
> > > >
> > > > Each time you type that name in text, you'll see a yellow tooltip that
> says
> > > > "Press Enter to insert". Actually, you can press Enter, Tab, or F3, as
> any
> > > > of them will insert the AutoText entry.
> > > >
> > > > If you insert new entries between existing ones, those that follow it
> don't
> > > > update automatically. You'll have to press Ctrl+A to select the whole
> > > > document and then press F9 to update the fields. (Alternatively,
> switch to
> > > > Print Preview and back.)
> > > >
> > > > ------------------------------------------
> > > >
> > > >
> > > >
> > > > HTH,
> > > >
> > > >
> > > > Pop`
> > > >
> > > >
> > > >
>
>
Back to top
Suzanne S. Barnhill
External


Since: Sep 26, 2003
Posts: 24483



PostPosted: Thu May 14, 2009 10:10 pm    Post subject: Re: WORD template - sequential numbering [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

You seem to be referring to
http://word.mvps.org/FAQs/MacrosVBA/NumberDocs.htm rather than the article
to which I directed you, http://www.gmayor.com/Numbered_labels.htm

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

"iaglarch" wrote in message

>I followed the instruction to create sequentially numbered documents (such
>as
> invoices) and the first document opened with the macro enters the specific
> number Order = 4209 instead of adding 1 + 4209. Can you tell me from the
> attached macro what I am doing incorrectly?
>
> Thanks,
>
> Sub AutoNew()
> '
> ' AutoNew Macro
> ' Macro created 5/14/2009 by VC of Finance
> '
> Order = System.PrivateProfileString("C:\Settings.Txt", "MacroSettings",
> "Order")
> If Order = "" Then
> Order = 4209
> Else
> Order = Order + 1
> End If
>
> System.PrivateProfileString("C:Settings.txt", "MacroSettings", "Order") =
> Order
>
> ActiveDocument.Bookmarks("Order").Range.InsertBefore Format(Order, "00#")
> ActiveDocument.SaveAs FileName:="path" & Format(Order, "00#")
>
>
> End Sub
>
>
>
>
>
> "Suzanne S. Barnhill" wrote:
>
>> You might want to see http://www.gmayor.com/Numbered_labels.htm
>>
>> --
>> Suzanne S. Barnhill
>> Microsoft MVP (Word)
>> Words into Type
>> Fairhope, Alabama USA
>> Word MVP FAQ site: http://word.mvps.org
>> Email cannot be acknowledged; please post all follow-ups to the newsgroup
>> so
>> all may benefit.
>>
>> "dgk" wrote in message
>>
>> > I tried the Autotext and it worked except it prints the (Q#). How do I
>> > aleviate the brackets and Q. Also do I have to do this 100 times for
>> > 100
>> > tickets?
>> >
>> > "dgk" wrote:
>> >
>> > > Thank you I will give that a try Smile
>> > >
>> > > "Pop`" wrote:
>> > >
>> > > > dgk wrote:
>> > > > > I am trying to figure out how to use this template:
>> > > > > http://office.microsoft.com/en-ca/templates/TC012265191033.aspx.
>> > > > > How
>> > > > > do I make 100 tickets and have the numbers automatically update?
>> > > >
>> > > > Huh! Good question! I expected to see a macro in the template, or
>> > > > at
>> least
>> > > > some way to keep the numbering going for successive pages. It
>> > > > looks
>> to me
>> > > > like someone "forgot" something. There's a Black & White version
>> > > > of
>> another
>> > > > one too, with the same problem.
>> > > >
>> > > > I've lost the source for where I got this, but here's a short blurb
>> > > > on
>> > > > creating sequential numbers if it helps any.
>> > > > -------------------
>> > > > Make an AutoText entry as follows: In the body of any document,
>> > > > type
>> the
>> > > > brackets and the letter Q as regular text. Between the Q and the
>> closing
>> > > > bracket, insert a Sequence field, which supplies the number. Now
>> select the
>> > > > whole thing and press Alt+F3 and assign a name to the AutoText
>> > > > entry
>> that
>> > > > you wouldn't ordinarily use as a word, such as "qtag".
>> > > >
>> > > > Each time you type that name in text, you'll see a yellow tooltip
>> > > > that
>> says
>> > > > "Press Enter to insert". Actually, you can press Enter, Tab, or F3,
>> > > > as
>> any
>> > > > of them will insert the AutoText entry.
>> > > >
>> > > > If you insert new entries between existing ones, those that follow
>> > > > it
>> don't
>> > > > update automatically. You'll have to press Ctrl+A to select the
>> > > > whole
>> > > > document and then press F9 to update the fields. (Alternatively,
>> switch to
>> > > > Print Preview and back.)
>> > > >
>> > > > ------------------------------------------
>> > > >
>> > > >
>> > > >
>> > > > HTH,
>> > > >
>> > > >
>> > > > Pop`
>> > > >
>> > > >
>> > > >
>>
>>
Back to top
Display posts from previous:   
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Document Management All times are: Eastern Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum