Bear with me as I'm new to this.
I thought I would create a macro to produce the necessary address labels to
save me and my people having to type in the whole process each time.
I selected Avery A4 and A5 sizes - L7159 but this info wasn't included in
the created macro.
When I run the macro it only placed four addresses on a page.
When I'm stepping through the process to create the macro there are 24
address labels per page, as expected.
Any ideas?

Thanks,
Jerry Slocombe
Still Learning

Why don't you just use mail merge?
http://www.officearticles.com/word/m...osoft_word.htm

You can save the mail merge document before you merge the labels. Change the
data source any time you like, run the merge again.

*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Jerry Slocombe" wrote in message
...
Bear with me as I'm new to this.
I thought I would create a macro to produce the necessary address labels
to
save me and my people having to type in the whole process each time.
I selected Avery A4 and A5 sizes - L7159 but this info wasn't included in
the created macro.
When I run the macro it only placed four addresses on a page.
When I'm stepping through the process to create the macro there are 24
address labels per page, as expected.
Any ideas?

Thanks,
Jerry Slocombe
Still Learning

Hi Anne,

Does your reply only apply to Word 2003?
I'm using Word 2000 and have different options to those advised in
http://www.officearticles.com/word/m...osoft_word.htm
--
Jerry Slocombe
Still Learning


"Anne Troy" wrote:

Why don't you just use mail merge?
http://www.officearticles.com/word/m...osoft_word.htm

You can save the mail merge document before you merge the labels. Change the
data source any time you like, run the merge again.

*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Jerry Slocombe" wrote in message
...
Bear with me as I'm new to this.
I thought I would create a macro to produce the necessary address labels
to
save me and my people having to type in the whole process each time.
I selected Avery A4 and A5 sizes - L7159 but this info wasn't included in
the created macro.
When I run the macro it only placed four addresses on a page.
When I'm stepping through the process to create the macro there are 24
address labels per page, as expected.
Any ideas?

Thanks,
Jerry Slocombe
Still Learning

Anne,

Are you saying that I can set up the correct 'template' for the labels and
then only have to change the data source?
If so, which file do I need to save - Labels1 or Document1?
I assume that I can then open that file and just change the data source?
Apologies for being slow but how do I do that?
--
Jerry Slocombe
Still Learning


"Jerry Slocombe" wrote:

Hi Anne,

Does your reply only apply to Word 2003?
I'm using Word 2000 and have different options to those advised in
http://www.officearticles.com/word/m...osoft_word.htm
--
Jerry Slocombe
Still Learning


"Anne Troy" wrote:

Why don't you just use mail merge?
http://www.officearticles.com/word/m...osoft_word.htm

You can save the mail merge document before you merge the labels. Change the
data source any time you like, run the merge again.

*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Jerry Slocombe" wrote in message
...
Bear with me as I'm new to this.
I thought I would create a macro to produce the necessary address labels
to
save me and my people having to type in the whole process each time.
I selected Avery A4 and A5 sizes - L7159 but this info wasn't included in
the created macro.
When I run the macro it only placed four addresses on a page.
When I'm stepping through the process to create the macro there are 24
address labels per page, as expected.
Any ideas?

Thanks,
Jerry Slocombe
Still Learning

No problem, Jerry.
Save Document1. Labels1 is the labels already created, right? Here's Mail
Merge for 2000:

http://www.theofficeexperts.com/word.htm#MailMerge
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com



"Jerry Slocombe" wrote in message
...
Anne,

Are you saying that I can set up the correct 'template' for the labels and
then only have to change the data source?
If so, which file do I need to save - Labels1 or Document1?
I assume that I can then open that file and just change the data source?
Apologies for being slow but how do I do that?
--
Jerry Slocombe
Still Learning


"Jerry Slocombe" wrote:

Hi Anne,

Does your reply only apply to Word 2003?
I'm using Word 2000 and have different options to those advised in

http://www.officearticles.com/word/m...osoft_word.htm
--
Jerry Slocombe
Still Learning


"Anne Troy" wrote:

Why don't you just use mail merge?

http://www.officearticles.com/word/m...osoft_word.htm

You can save the mail merge document before you merge the labels.
Change the
data source any time you like, run the merge again.

*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Jerry Slocombe" wrote in
message
...
Bear with me as I'm new to this.
I thought I would create a macro to produce the necessary address
labels
to
save me and my people having to type in the whole process each time.
I selected Avery A4 and A5 sizes - L7159 but this info wasn't
included in
the created macro.
When I run the macro it only placed four addresses on a page.
When I'm stepping through the process to create the macro there are
24
address labels per page, as expected.
Any ideas?

Thanks,
Jerry Slocombe
Still Learning

Hi Anne,

Thanks for your help. I can now open the 'template' (Document1) before
hitting Mail Merge to select the data source before merging and printing.
The next challenge for me is to create a macro that:-
1. Opens the template - done that
2. GetFileName for data source - not sure about that. Assume I add a
command button but don't know the code
3. Merge the data - I can plagiarise that from previous macro
4. Print labels - ditto, as above
I used to be a programmer some 15 years ago but I'm a little rusty, as if
you hadn't guessed, and I've never used VB!
--
Jerry Slocombe
Still Learning


"Anne Troy" wrote:

No problem, Jerry.
Save Document1. Labels1 is the labels already created, right? Here's Mail
Merge for 2000:

http://www.theofficeexperts.com/word.htm#MailMerge
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com



"Jerry Slocombe" wrote in message
...
Anne,

Are you saying that I can set up the correct 'template' for the labels and
then only have to change the data source?
If so, which file do I need to save - Labels1 or Document1?
I assume that I can then open that file and just change the data source?
Apologies for being slow but how do I do that?
--
Jerry Slocombe
Still Learning


"Jerry Slocombe" wrote:

Hi Anne,

Does your reply only apply to Word 2003?
I'm using Word 2000 and have different options to those advised in

http://www.officearticles.com/word/m...osoft_word.htm
--
Jerry Slocombe
Still Learning


"Anne Troy" wrote:

Why don't you just use mail merge?

http://www.officearticles.com/word/m...osoft_word.htm

You can save the mail merge document before you merge the labels.
Change the
data source any time you like, run the merge again.

*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Jerry Slocombe" wrote in
message
...
Bear with me as I'm new to this.
I thought I would create a macro to produce the necessary address
labels
to
save me and my people having to type in the whole process each time.
I selected Avery A4 and A5 sizes - L7159 but this info wasn't
included in
the created macro.
When I run the macro it only placed four addresses on a page.
When I'm stepping through the process to create the macro there are
24
address labels per page, as expected.
Any ideas?

Thanks,
Jerry Slocombe
Still Learning