2. There's a button on the mail merge toolbar to "open data source".
And, I THINK You might be able to record these macros, Jerry.
http://www.officearticles.com/word/r...osoft_word.htm
*******************
~Anne Troy
www.OfficeArticles.com
www.MyExpertsOnline.com
"Jerry Slocombe" wrote in message
...
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