Unsolved
This post is more than 5 years old
33 Posts
0
3848
August 23rd, 2005 13:00
Sorting Mail Merge in Word
I am using Office 2000.
I have a database in Access 2000 that I want to use to print envelopes in Word.
I can merge into Word okay and print the envelopes but they don't print in the same (alpha)order as the database.
When I use the options menu in the Word Mail Merge the "Sort Option" is grayed out and not available.
Is there some way to sort the envelopes?
0 events found
No Events found!
abach
1.7K Posts
0
August 23rd, 2005 23:00
ajensens
33 Posts
0
August 23rd, 2005 23:00
abach
1.7K Posts
0
August 24th, 2005 00:00
I normally don't use queries because of the sorting issue. Word cannot sort Access queries when used as a data source. Have you tried sorting the query in design view? That may work.
If not, I recommend using a make table query to make a temporary table to hold your records. If you need help with this, let me know.
ajensens
33 Posts
0
August 25th, 2005 23:00
Thanks for your help. I used a table instead of a query, filtered out what I didn't want, and then was able to sort.
AJ