How do I save mailing labels resulting from a mail merge?

With Office 97 I was able to create mailing lists from mail merge and save
the file for future use. With Office 2003, Office creates a query, not the
one I used to create the original labels, to generate the labels and they are
not the same.

I have tried mail merge directly from an Access query and from a spreadsheet
generated by the same query. In both cases I get the same wrong result when I
try to reuse the file.

Thanks for your help

Wayne Brady

Which application are you referring to specifically? Word can create
mailing labels and Access can too.

Are you saying you used to save the completed mail merge labels for
future use in Word 97?

This can still be done in Word 2003 so can you try clarifying the
issue a little more? What application are you using and what are the
exact steps you are using?

Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/


"Wayne Brady" Wayne wrote in message
...
With Office 97 I was able to create mailing lists from mail merge
and save
the file for future use. With Office 2003, Office creates a query,
not the
one I used to create the original labels, to generate the labels and
they are
not the same.

I have tried mail merge directly from an Access query and from a
spreadsheet
generated by the same query. In both cases I get the same wrong
result when I
try to reuse the file.

Thanks for your help

Wayne Brady

I had not tried to us Access for mailing labels. That sounds like a good
idea. I have been using Word to generate the mailing labels. The thing that
puzzles me is the fact that when I saved the labels in the past, it was a
simple word document. Now, it seems to have a function built in that
generates a new query.

Wayne

"Beth Melton" wrote:

Which application are you referring to specifically? Word can create
mailing labels and Access can too.

Are you saying you used to save the completed mail merge labels for
future use in Word 97?

This can still be done in Word 2003 so can you try clarifying the
issue a little more? What application are you using and what are the
exact steps you are using?

Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/


"Wayne Brady" Wayne wrote in message
...
With Office 97 I was able to create mailing lists from mail merge
and save
the file for future use. With Office 2003, Office creates a query,
not the
one I used to create the original labels, to generate the labels and
they are
not the same.

I have tried mail merge directly from an Access query and from a
spreadsheet
generated by the same query. In both cases I get the same wrong
result when I
try to reuse the file.

Thanks for your help

Wayne Brady

Ah! Did you click "Edit Individual Labels" on the last step of the
Mail Merge Wizard? I think that's what you are missing - otherwise the
merge hasn't been completed.

Personally I just turn on the Mail Merge toolbar and by-pass new "Mail
Merge Wizard". Just use the commands on the toolbar from left to right
and you'll have everything you need So much easier!

Although, if interested in using the Mail Merge toolbar instead you'll
also want to add the "Insert Merge Field" command:

- Go to Tools/Customize
- On the Commands tab select "All Commands"
- Find "InsertMergeField" in the commands
- Drag/drop on the Mail Merge toolbar

Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/


"Wayne Brady" wrote in message
...
I had not tried to us Access for mailing labels. That sounds like a
good
idea. I have been using Word to generate the mailing labels. The
thing that
puzzles me is the fact that when I saved the labels in the past, it
was a
simple word document. Now, it seems to have a function built in that
generates a new query.

Thank you very much for your help. I really appreciated the rapidness of the
response and the usefulness of your suggestions.

Wayne
"Beth Melton" wrote:

Ah! Did you click "Edit Individual Labels" on the last step of the
Mail Merge Wizard? I think that's what you are missing - otherwise the
merge hasn't been completed.

Personally I just turn on the Mail Merge toolbar and by-pass new "Mail
Merge Wizard". Just use the commands on the toolbar from left to right
and you'll have everything you need So much easier!

Although, if interested in using the Mail Merge toolbar instead you'll
also want to add the "Insert Merge Field" command:

- Go to Tools/Customize
- On the Commands tab select "All Commands"
- Find "InsertMergeField" in the commands
- Drag/drop on the Mail Merge toolbar

Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/


"Wayne Brady" wrote in message
...
I had not tried to us Access for mailing labels. That sounds like a
good
idea. I have been using Word to generate the mailing labels. The
thing that
puzzles me is the fact that when I saved the labels in the past, it
was a
simple word document. Now, it seems to have a function built in that
generates a new query.

On Sun, 21 Aug 2005 07:30:04 -0700, "Wayne Brady"
wrote:

I had not tried to us Access for mailing labels. That sounds like a good
idea. I have been using Word to generate the mailing labels. The thing that
puzzles me is the fact that when I saved the labels in the past, it was a
simple word document. Now, it seems to have a function built in that
generates a new query.

Wayne

Most programs which can design and print mailing labels also have an
option to either print them to a file, or print them to the printer.

Donald McDaniel


"Beth Melton" wrote:

Which application are you referring to specifically? Word can create
mailing labels and Access can too.

Are you saying you used to save the completed mail merge labels for
future use in Word 97?

This can still be done in Word 2003 so can you try clarifying the
issue a little more? What application are you using and what are the
exact steps you are using?

Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/


"Wayne Brady" Wayne wrote in message
...
With Office 97 I was able to create mailing lists from mail merge
and save
the file for future use. With Office 2003, Office creates a query,
not the
one I used to create the original labels, to generate the labels and
they are
not the same.

I have tried mail merge directly from an Access query and from a
spreadsheet
generated by the same query. In both cases I get the same wrong
result when I
try to reuse the file.

Thanks for your help

Wayne Brady



Donald L McDaniel
Please reply to the original thread
so that conversations may be kept in order
================================================== =====