I have a template which I use but the only entries I have to make is a
person's name but this name has to go 4 times in the doc. Is there any way I
can get the name to repeat in all 4 places once I put it in the first one e.g

John Ryan

I refer to the death of John Ryan

Please concact me re John Ryan

Please register John Ryan

Hi BER,

The easiest way to accomplish this is by using one ASK field in combination
with four REF fields; see Insert | Field...
You have to supply a bookmark with the ASK field. Type the name of that
bookmark in your REF fields and they will show what your user typed in the
ASK field.

Success,
Cooz
--
PS: If this is a satisfying answer to your question and you're logged in via
the Microsoft site, please click Yes to "Did this post answer the question?".
Thanks.

"BER" wrote:

I have a template which I use but the only entries I have to make is a
person's name but this name has to go 4 times in the doc. Is there any way I
can get the name to repeat in all 4 places once I put it in the first one e.g

John Ryan

I refer to the death of John Ryan

Please concact me re John Ryan

Please register John Ryan

See:
http://gregmaxey.mvps.org/Repeating_Data.htm

Cooz,

An ASK field does not fire a prompt on creating new document from a
template.

See:
http://gregmaxey.mvps.org/Repeating_Data.htm

Hi BER,

In addition to what I suggested, with thanks to Greg, you should record a
(any) macro in the template on which your document is based. For example:
start recording, click the B (Bold) button in the formatting toolbar, and
stop recording.

Choose Tools | Macro Macros..., select your macro and click Edit. The VBA
editor opens.
Replace _all_ of the currently selected macro with

Sub AutoNew()
ActiveDocument..Fields.Update
End Sub

Click the Save button in the VBA editor, return to Word and close Word. From
now on, the ASK field _will_ fire a prompt on creating new document.

Success,
Cooz
--
PS: If this is a satisfying answer to your question and you're logged in via
the Microsoft site, please click Yes to "Did this post answer the question?".
Thanks.

"Cooz" wrote:

Hi BER,

The easiest way to accomplish this is by using one ASK field in combination
with four REF fields; see Insert | Field...
You have to supply a bookmark with the ASK field. Type the name of that
bookmark in your REF fields and they will show what your user typed in the
ASK field.

Success,
Cooz
--
PS: If this is a satisfying answer to your question and you're logged in via
the Microsoft site, please click Yes to "Did this post answer the question?".
Thanks.

"BER" wrote:

I have a template which I use but the only entries I have to make is a
person's name but this name has to go 4 times in the doc. Is there any way I
can get the name to repeat in all 4 places once I put it in the first one e.g

John Ryan

I refer to the death of John Ryan

Please concact me re John Ryan

Please register John Ryan

Greg,

You are absolutely right. I have provided a necessary addition to my first
reply.

Thank you,
Cooz


"Greg" wrote:

Cooz,

An ASK field does not fire a prompt on creating new document from a
template.

See:
http://gregmaxey.mvps.org/Repeating_Data.htm

Cooz You are a bit ahead of me here, I use fields and fieldswitches and
macros but cannot get this one to work, maybe a bit more step by step for me
please. What I need in these fields is to be able to type any name and it
will repeat in the four other fields. Sorry maybe I'm a bit slow today or not
as advanced as you in word I guess. Just cannot follow your initial insert
field instructions.

"Cooz" wrote:

Hi BER,

In addition to what I suggested, with thanks to Greg, you should record a
(any) macro in the template on which your document is based. For example:
start recording, click the B (Bold) button in the formatting toolbar, and
stop recording.

Choose Tools | Macro Macros..., select your macro and click Edit. The VBA
editor opens.
Replace _all_ of the currently selected macro with

Sub AutoNew()
ActiveDocument..Fields.Update
End Sub

Click the Save button in the VBA editor, return to Word and close Word. From
now on, the ASK field _will_ fire a prompt on creating new document.

Success,
Cooz
--
PS: If this is a satisfying answer to your question and you're logged in via
the Microsoft site, please click Yes to "Did this post answer the question?".
Thanks.

"Cooz" wrote:

Hi BER,

The easiest way to accomplish this is by using one ASK field in combination
with four REF fields; see Insert | Field...
You have to supply a bookmark with the ASK field. Type the name of that
bookmark in your REF fields and they will show what your user typed in the
ASK field.

Success,
Cooz
--
PS: If this is a satisfying answer to your question and you're logged in via
the Microsoft site, please click Yes to "Did this post answer the question?".
Thanks.

"BER" wrote:

I have a template which I use but the only entries I have to make is a
person's name but this name has to go 4 times in the doc. Is there any way I
can get the name to repeat in all 4 places once I put it in the first one e.g

John Ryan

I refer to the death of John Ryan

Please concact me re John Ryan

Please register John Ryan

I submit again.

See:
http://gregmaxey.mvps.org/Repeating_Data.htm

Hi BER,

In your template, where the first name should appear, type:

{ ASK bmkName "Please type your name" }{ bmkName }

Insert the { } with Ctrl-F9, and type the rest. When you update the field
(select the paragraph and press F9), you are prompted to type your name by
the ASK-field. This field in addition connects whatever you type to
"bmkName". See "bmkName" as a box in which you put something, namely your
name.

{ bmkName } displays the contents of the box. Wherever you insert this
field, what you typed in the ASK-field is reflected. In order for this to
work, the fields must be updated (as stated earlier). This is not done
automatically, hence the macro. Create it as follows:

Open the template, record any macro, say record clicking the B-button on the
Standard toolbar, and be sure to choose the template under 'Store macro in'.
Choose Tools | Macro Macro's..., select your macro and choose Edit. The
VBA-editor opens.
Replace the entire macro by the following:

Sub AutoNew()
ActiveDocument.Fields.Update
End Sub

Click the Save button in the VBA editor to save the template. Close the
editor. Close the template. There you are.

Good luck,
Cooz
--
PS: If this is a satisfying answer to your question and you're logged in via
the Microsoft site, please click Yes to "Did this post answer the question?".
Thanks.


"BER" wrote:

Cooz You are a bit ahead of me here, I use fields and fieldswitches and
macros but cannot get this one to work, maybe a bit more step by step for me
please. What I need in these fields is to be able to type any name and it
will repeat in the four other fields. Sorry maybe I'm a bit slow today or not
as advanced as you in word I guess. Just cannot follow your initial insert
field instructions.

"Cooz" wrote:

Hi BER,

In addition to what I suggested, with thanks to Greg, you should record a
(any) macro in the template on which your document is based. For example:
start recording, click the B (Bold) button in the formatting toolbar, and
stop recording.

Choose Tools | Macro Macros..., select your macro and click Edit. The VBA
editor opens.
Replace _all_ of the currently selected macro with

Sub AutoNew()
ActiveDocument..Fields.Update
End Sub

Click the Save button in the VBA editor, return to Word and close Word. From
now on, the ASK field _will_ fire a prompt on creating new document.

Success,
Cooz
--
PS: If this is a satisfying answer to your question and you're logged in via
the Microsoft site, please click Yes to "Did this post answer the question?".
Thanks.

"Cooz" wrote:

Hi BER,

The easiest way to accomplish this is by using one ASK field in combination
with four REF fields; see Insert | Field...
You have to supply a bookmark with the ASK field. Type the name of that
bookmark in your REF fields and they will show what your user typed in the
ASK field.

Success,
Cooz
--
PS: If this is a satisfying answer to your question and you're logged in via
the Microsoft site, please click Yes to "Did this post answer the question?".
Thanks.

"BER" wrote:

I have a template which I use but the only entries I have to make is a
person's name but this name has to go 4 times in the doc. Is there any way I
can get the name to repeat in all 4 places once I put it in the first one e.g

John Ryan

I refer to the death of John Ryan

Please concact me re John Ryan

Please register John Ryan

Cooz,

What is the point is posting an answer that has already been given?

Hi Greg,

BER addressed me personally in his last reaction. So I thought it would be
polite to reply.

Cooz


"Greg" wrote:

Cooz,

What is the point is posting an answer that has already been given?

I suppose that is reason enough.

--
Greg Maxey/Word MVP
See:
http://gregmaxey.mvps.org/word_tips.htm
For some helpful tips using Word.


Cooz wrote:
Hi Greg,

BER addressed me personally in his last reaction. So I thought it
would be polite to reply.

Cooz


"Greg" wrote:

Cooz,

What is the point is posting an answer that has already been given?

Hi,

I've used the information contained at this hyperlink. However, when I am
at step 10, I am confused. I don't know VBA, and am only following your
directions.

1. I presume where the "Text1" and "Text2" is written that I use the names I
have assigned to the text boxes? Do I use the inverted commas?
2. Where it says Range_, what goes after the underscore? I've read about
the Range command and I think it means for me to indicate the section of the
document to which the bookmark applies. My bookmarks appy throughout my
document.
3. Where it says ActiveDocument, do I type ActiveDocument, or does that mean
I enter the name of my Word document?
4. It says "Repeat the lines beginning with .Bookmarks for each bookmark".
Am I supposed to repeat the line beginning .InsertBefore for each bookmark?
5. On the line starting with .InsertBefore, am I supposed to be able to
select "InsertBefore" from the drop down menu that appears? It doesn't seem
to be there.
6. On the line starting with.InsertBefore, where it refers to TextBox 1, I
presume I am to include the names I have given each text box. Is there a way
to access the names of my textboxes rather than write them all down?

Thanks,

Jane

"Greg" wrote:

See:
http://gregmaxey.mvps.org/Repeating_Data.htm

1. Yes you presume correctly. What inverted commas?
2. Just remove the underscore and use somethimg like this all on one line:

..Bookmarks("Text1").Range.InsertBefore TextBox1

You would repeat this for each additional Bookmark that you want to assign
text from a Userform field. If you are simply repeating the same data at
various locations then just use one Userform textbox and one bookmark. Then
use REF fields for the other locations.

3. It means ActiveDocument and that is what you type.
4. See 2. above
5. If you type the data statement out as one line, after you type Range.
then the InsertBefore should appear in the list.
6. You assume correctly
7. You can shift back between the code view and object view of the form if
you want to see the control names.

--
Greg Maxey/Word MVP
See:
http://gregmaxey.mvps.org/word_tips.htm
For some helpful tips using Word.


Jane wrote:
Hi,

I've used the information contained at this hyperlink. However, when
I am at step 10, I am confused. I don't know VBA, and am only
following your directions.

1. I presume where the "Text1" and "Text2" is written that I use the
names I have assigned to the text boxes? Do I use the inverted
commas?
2. Where it says Range_, what goes after the underscore? I've read
about the Range command and I think it means for me to indicate the
section of the document to which the bookmark applies. My bookmarks
appy throughout my document.
3. Where it says ActiveDocument, do I type ActiveDocument, or does
that mean I enter the name of my Word document?
4. It says "Repeat the lines beginning with .Bookmarks for each
bookmark". Am I supposed to repeat the line beginning .InsertBefore
for each bookmark?
5. On the line starting with .InsertBefore, am I supposed to be able
to select "InsertBefore" from the drop down menu that appears? It
doesn't seem to be there.
6. On the line starting with.InsertBefore, where it refers to TextBox
1, I presume I am to include the names I have given each text box.
Is there a way to access the names of my textboxes rather than write
them all down?

Thanks,

Jane

"Greg" wrote:

See:
http://gregmaxey.mvps.org/Repeating_Data.htm

Hi,

Thanks, all is now well with the userform and bookmarked fields. However,
there are a few times when I repeat one of the fields. I have:

1. Created a bookmark called "Company_Name" and inserted it at one point in
the template document. This works without any problem.
2. Clicked Insert Field Ref and selected the bookmark "Company_Name".

However, the information that appears where I have inserted the original
bookmark is not visible in the places where I have inserted the ref field.

How to I overcome this?

Jane


"Greg Maxey" wrote:

1. Yes you presume correctly. What inverted commas?
2. Just remove the underscore and use somethimg like this all on one line:

..Bookmarks("Text1").Range.InsertBefore TextBox1

You would repeat this for each additional Bookmark that you want to assign
text from a Userform field. If you are simply repeating the same data at
various locations then just use one Userform textbox and one bookmark. Then
use REF fields for the other locations.

3. It means ActiveDocument and that is what you type.
4. See 2. above
5. If you type the data statement out as one line, after you type Range.
then the InsertBefore should appear in the list.
6. You assume correctly
7. You can shift back between the code view and object view of the form if
you want to see the control names.

--
Greg Maxey/Word MVP
See:
http://gregmaxey.mvps.org/word_tips.htm
For some helpful tips using Word.


Jane wrote:
Hi,

I've used the information contained at this hyperlink. However, when
I am at step 10, I am confused. I don't know VBA, and am only
following your directions.

1. I presume where the "Text1" and "Text2" is written that I use the
names I have assigned to the text boxes? Do I use the inverted
commas?
2. Where it says Range_, what goes after the underscore? I've read
about the Range command and I think it means for me to indicate the
section of the document to which the bookmark applies. My bookmarks
appy throughout my document.
3. Where it says ActiveDocument, do I type ActiveDocument, or does
that mean I enter the name of my Word document?
4. It says "Repeat the lines beginning with .Bookmarks for each
bookmark". Am I supposed to repeat the line beginning .InsertBefore
for each bookmark?
5. On the line starting with .InsertBefore, am I supposed to be able
to select "InsertBefore" from the drop down menu that appears? It
doesn't seem to be there.
6. On the line starting with.InsertBefore, where it refers to TextBox
1, I presume I am to include the names I have given each text box.
Is there a way to access the names of my textboxes rather than write
them all down?

Thanks,

Jane

"Greg" wrote:

See:
http://gregmaxey.mvps.org/Repeating_Data.htm

Jane,

Change your Userform calling macro to something like this.

Dim myFrm as Userform1
Set myFrm = New Userform1
Userform1.Show
Unload myFrm
Set myFrm = Nothing
ActiveDocument.Fields.Update


--
Greg Maxey/Word MVP
See:
http://gregmaxey.mvps.org/word_tips.htm
For some helpful tips using Word.


Jane wrote:
Hi,

Thanks, all is now well with the userform and bookmarked fields.
However, there are a few times when I repeat one of the fields. I
have:

1. Created a bookmark called "Company_Name" and inserted it at one
point in the template document. This works without any problem.
2. Clicked Insert Field Ref and selected the bookmark
"Company_Name".

However, the information that appears where I have inserted the
original bookmark is not visible in the places where I have inserted
the ref field.

How to I overcome this?

Jane


"Greg Maxey" wrote:

1. Yes you presume correctly. What inverted commas?
2. Just remove the underscore and use somethimg like this all on
one line:

..Bookmarks("Text1").Range.InsertBefore TextBox1

You would repeat this for each additional Bookmark that you want to
assign text from a Userform field. If you are simply repeating the
same data at various locations then just use one Userform textbox
and one bookmark. Then use REF fields for the other locations.

3. It means ActiveDocument and that is what you type.
4. See 2. above
5. If you type the data statement out as one line, after you type
Range. then the InsertBefore should appear in the list.
6. You assume correctly
7. You can shift back between the code view and object view of the
form if you want to see the control names.

--
Greg Maxey/Word MVP
See:
http://gregmaxey.mvps.org/word_tips.htm
For some helpful tips using Word.


Jane wrote:
Hi,

I've used the information contained at this hyperlink. However,
when I am at step 10, I am confused. I don't know VBA, and am only
following your directions.

1. I presume where the "Text1" and "Text2" is written that I use the
names I have assigned to the text boxes? Do I use the inverted
commas?
2. Where it says Range_, what goes after the underscore? I've read
about the Range command and I think it means for me to indicate the
section of the document to which the bookmark applies. My bookmarks
appy throughout my document.
3. Where it says ActiveDocument, do I type ActiveDocument, or does
that mean I enter the name of my Word document?
4. It says "Repeat the lines beginning with .Bookmarks for each
bookmark". Am I supposed to repeat the line beginning .InsertBefore
for each bookmark?
5. On the line starting with .InsertBefore, am I supposed to be able
to select "InsertBefore" from the drop down menu that appears? It
doesn't seem to be there.
6. On the line starting with.InsertBefore, where it refers to
TextBox 1, I presume I am to include the names I have given each
text box. Is there a way to access the names of my textboxes rather
than write them all down?

Thanks,

Jane

"Greg" wrote:

See:
http://gregmaxey.mvps.org/Repeating_Data.htm

Hi Greg,

I'm sorry, but I don't know what a calling macro is. I've tried looking up
some of the text in the help menu, but the responses are all gobblydegook to
me. Perhaps I'm trying to achieve something far too advanced for my
capabilities, but I think I'm almost there. Any other explanations you can
provide will be most appreciated.

I really have no knowledge of VBA at all.

Jane

"Greg Maxey" wrote:

Jane,

Change your Userform calling macro to something like this.

Dim myFrm as Userform1
Set myFrm = New Userform1
Userform1.Show
Unload myFrm
Set myFrm = Nothing
ActiveDocument.Fields.Update


--
Greg Maxey/Word MVP
See:
http://gregmaxey.mvps.org/word_tips.htm
For some helpful tips using Word.


Jane wrote:
Hi,

Thanks, all is now well with the userform and bookmarked fields.
However, there are a few times when I repeat one of the fields. I
have:

1. Created a bookmark called "Company_Name" and inserted it at one
point in the template document. This works without any problem.
2. Clicked Insert Field Ref and selected the bookmark
"Company_Name".

However, the information that appears where I have inserted the
original bookmark is not visible in the places where I have inserted
the ref field.

How to I overcome this?

Jane


"Greg Maxey" wrote:

1. Yes you presume correctly. What inverted commas?
2. Just remove the underscore and use somethimg like this all on
one line:

..Bookmarks("Text1").Range.InsertBefore TextBox1

You would repeat this for each additional Bookmark that you want to
assign text from a Userform field. If you are simply repeating the
same data at various locations then just use one Userform textbox
and one bookmark. Then use REF fields for the other locations.

3. It means ActiveDocument and that is what you type.
4. See 2. above
5. If you type the data statement out as one line, after you type
Range. then the InsertBefore should appear in the list.
6. You assume correctly
7. You can shift back between the code view and object view of the
form if you want to see the control names.

--
Greg Maxey/Word MVP
See:
http://gregmaxey.mvps.org/word_tips.htm
For some helpful tips using Word.


Jane wrote:
Hi,

I've used the information contained at this hyperlink. However,
when I am at step 10, I am confused. I don't know VBA, and am only
following your directions.

1. I presume where the "Text1" and "Text2" is written that I use the
names I have assigned to the text boxes? Do I use the inverted
commas?
2. Where it says Range_, what goes after the underscore? I've read
about the Range command and I think it means for me to indicate the
section of the document to which the bookmark applies. My bookmarks
appy throughout my document.
3. Where it says ActiveDocument, do I type ActiveDocument, or does
that mean I enter the name of my Word document?
4. It says "Repeat the lines beginning with .Bookmarks for each
bookmark". Am I supposed to repeat the line beginning .InsertBefore
for each bookmark?
5. On the line starting with .InsertBefore, am I supposed to be able
to select "InsertBefore" from the drop down menu that appears? It
doesn't seem to be there.
6. On the line starting with.InsertBefore, where it refers to
TextBox 1, I presume I am to include the names I have given each
text box. Is there a way to access the names of my textboxes rather
than write them all down?

Thanks,

Jane

"Greg" wrote:

See:
http://gregmaxey.mvps.org/Repeating_Data.htm

Jane,

Sorry for the confusion. The calling macro is the macro that creates the
userform (that's what I call it anyway, and I'm not dead certain that I am
correct). I suspect that right now you are using something like

Sub SomethingorOther
UserForm1.Show
End Sub



--
Greg Maxey/Word MVP
See:
http://gregmaxey.mvps.org/word_tips.htm
For some helpful tips using Word.

"Jane" wrote in message
...
Hi Greg,

I'm sorry, but I don't know what a calling macro is. I've tried looking
up
some of the text in the help menu, but the responses are all gobblydegook
to
me. Perhaps I'm trying to achieve something far too advanced for my
capabilities, but I think I'm almost there. Any other explanations you
can
provide will be most appreciated.

I really have no knowledge of VBA at all.

Jane

"Greg Maxey" wrote:

Jane,

Change your Userform calling macro to something like this.

Dim myFrm as Userform1
Set myFrm = New Userform1
Userform1.Show
Unload myFrm
Set myFrm = Nothing
ActiveDocument.Fields.Update


--
Greg Maxey/Word MVP
See:
http://gregmaxey.mvps.org/word_tips.htm
For some helpful tips using Word.


Jane wrote:
Hi,

Thanks, all is now well with the userform and bookmarked fields.
However, there are a few times when I repeat one of the fields. I
have:

1. Created a bookmark called "Company_Name" and inserted it at one
point in the template document. This works without any problem.
2. Clicked Insert Field Ref and selected the bookmark
"Company_Name".

However, the information that appears where I have inserted the
original bookmark is not visible in the places where I have inserted
the ref field.

How to I overcome this?

Jane


"Greg Maxey" wrote:

1. Yes you presume correctly. What inverted commas?
2. Just remove the underscore and use somethimg like this all on
one line:

..Bookmarks("Text1").Range.InsertBefore TextBox1

You would repeat this for each additional Bookmark that you want to
assign text from a Userform field. If you are simply repeating the
same data at various locations then just use one Userform textbox
and one bookmark. Then use REF fields for the other locations.

3. It means ActiveDocument and that is what you type.
4. See 2. above
5. If you type the data statement out as one line, after you type
Range. then the InsertBefore should appear in the list.
6. You assume correctly
7. You can shift back between the code view and object view of the
form if you want to see the control names.

--
Greg Maxey/Word MVP
See:
http://gregmaxey.mvps.org/word_tips.htm
For some helpful tips using Word.


Jane wrote:
Hi,

I've used the information contained at this hyperlink. However,
when I am at step 10, I am confused. I don't know VBA, and am only
following your directions.

1. I presume where the "Text1" and "Text2" is written that I use the
names I have assigned to the text boxes? Do I use the inverted
commas?
2. Where it says Range_, what goes after the underscore? I've read
about the Range command and I think it means for me to indicate the
section of the document to which the bookmark applies. My bookmarks
appy throughout my document.
3. Where it says ActiveDocument, do I type ActiveDocument, or does
that mean I enter the name of my Word document?
4. It says "Repeat the lines beginning with .Bookmarks for each
bookmark". Am I supposed to repeat the line beginning .InsertBefore
for each bookmark?
5. On the line starting with .InsertBefore, am I supposed to be able
to select "InsertBefore" from the drop down menu that appears? It
doesn't seem to be there.
6. On the line starting with.InsertBefore, where it refers to
TextBox 1, I presume I am to include the names I have given each
text box. Is there a way to access the names of my textboxes rather
than write them all down?

Thanks,

Jane

"Greg" wrote:

See:
http://gregmaxey.mvps.org/Repeating_Data.htm